Open a form and show a specific subform record (1 Viewer)

Hello!

So, i have a form that has a bunch of tabs (navigation subform).
I want to by selecting a record on another form, open the main form, and show a specific record on the first tab (subform).

How do i do this using macros?

Thank You!

I don't like and NEVER use Navigation form. Conventional approach is to filter main form and then subforms only show records related to the main form record. Since I also never use macros, I am not even sure what you want can be done with macros.

actually this may be late in the day but this can be easily achieved by adding a button to the 1st form (use the wizard) and select the option open form > (your 2nd form) a specific record with matching fields.

Button wizard = Form operations>open form>open form show specific data

The wizard will ask you to link the the field in the 1st form with a field in the 2nd form.

if this is done correctly it will open the 2nd form with only the matching records specified in the 1st one