Access 2000 Macro Filter

By scott ·

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.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums