Open Subform on main menu to show specific date

[Guest]

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

 

[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

 

[Guest]

Thanks - That looks like it worked.

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

 

[tina]

you're welcome, hope it did.

Thanks - That looks like it worked.