Opening a subform on a record from the mainform and still be able to navigate.

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

Guest

I am trying to open a sub form using the Openform macro
I want to open the subform displaying a certain record from the main form… I can do that using the “Where condition†in Open form – but then it is creating a filter and I cannot navigate between the rest of the records in the subform without first doing an “Remove Filterâ€
How can I open the subform on the record specify in the mainform and still be able to navigate between the records
Many thanks
 
Kokliko,

I believe you are using the word 'subform' incorrectly. It sounds like
you are really opening a second separate form. I think to achieve what
you want, you will need to use the OpenForm action to open the secong
form, no Where condition, and then follow it with a GoToControl action
to set the focus to the key field that defines the link to the first
form, and then a FindRecord action to move to the required record. The
entry for the Find What argument will be something like...
=[Forms]![NameOfFirstForm]![NameOfKeyField]
 
Back
Top