Refresh a sub form within a form

[Guest]

i have a form called 'work orders' and within that form i have a sub form
called 'materials' which is displayed as a datasheet. when i open my form
'work orders' and start to input data the datasheet 'Materials' wont allow
any data entry. No Rows, just headings. My datasheet is filtered by work
order ID which is an autonumber when the 'work orders' opens. When i open my
from 'work orders' and start to input data the work order ID is given an auto
number. I then have to close the form 'work orders' and open it again for the
datasheet to become active because of the filter. the datashhet is in a tab
control so i have tried onclick of the tab control to requery the forms but
it doesnt work. any ideas on how to get the dataview form to work without
having to close and reopen the form.

 

[Guest]

Hi, StuJol.

You don't need a filter; remove it and set the subform's LinkMasterFields
and LinkChildFields to the name of the primary key field of the master form's
RecordSource, and the name of the corresponding foreign key in the subform's
RecordSource. Presumably, these will both be the WorkOrderID from WorkOrders
and Materials tables, respectively.

Sprinks

 

[Guest]

What you have surgested is the way it is currently configured, i used the
term filter instead of the term masterlink fields. My mistake.