Greetings,
I am using an option group on a form to have a group of buttons to open different forms from a master form. I have a macro to open the individual forms based on each button.
I need a way to filter the record that is opened in the form based on the main form. I have a common key and I tried to put this expression in the where field of the macro: [nameSubKEY] = 1. nameSubKEY is the child key to the primary key NameKEY. 1 is the autonumber to number connection.
When I created a linked subform with the wizard the connection worked, but I cannot figure out how to make more than 1 button that works. So I am trying this macro approach.
Any help would be appreciated. Please be gentle, I am not a coder. Everything I know from brute force figuring it out.
Best,
Scott
