Open Subform on main menu to show specific date

W

Waitsu

I have created a menu form which has a subform in it and what I want to do to
is the following:

When the Main Menu opens I want the subform to open to a specific record.
The Main Menu has a field called 'Turnover Date' and so does the sub-form.

I want to open the sub-form so that the Turnover Dates match or if there is
no matching date in the sub-form then open a blank record for the subform.

I know it can be done, I just can not remember how to do it.

Any help would be greatly appreciated.

Thanks
 
T

tina

in the subform control within the main form, set the LinkChildFields and
LinkMasterFields properties to the corresponding date fields in the subform
and main form.

hth
 
W

Waitsu

Thanks - That looks like it worked.

tina said:
in the subform control within the main form, set the LinkChildFields and
LinkMasterFields properties to the corresponding date fields in the subform
and main form.

hth
Click to expand...
 
Top