Cant edit subform within a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform named "Work Orders - Materials Subform" within a parent form
called "Work Orders". The subforms link child fields and link master fields
are set to "Work Order ID". (Work Order ID = Autonumber) When you open the
parent form it opens as a new
record therefore no work order ID is assigned to the parent form and subform.
When a user starts to input data, a work order ID is created in the parent
form but not in the subform. as a result of this the subform (Which is in
dataview) cant be edited. You have to close the parent form and then reopen
the parent form in order to be able to edit the subform.

When i open the parent form there is no work order id created from the
autonumber, therefore the subform isnt linked to any work order id. When a
work order id is given to the main form via the autonumber, the work order id
number isnt transferred to the subform. You have to close the form and reopen
the form to link the main form and subform together via the work order id
number.

Does anyone know how i can edit/add to my subform without having to close and
reopen the parent form.

Thanks to anyone who looks into this.
 
created a form "Work Orders", which is the parent form from a table called
"Work Orders. Then i inserted a subform into the parent form using the wizard
and link "Work Order ID" to both forms. Is this what you mean??
 
I've created many forms in the way you describe, and I've never had problems
with new records in the parent form. Well, except I've never had to
manually link the WorkOrderID..it always either just does it automatically
or asks. Have you tried starting over?

-Amy
 
Back
Top