Question

Locked

Access 2000 Macro Filter

By scott ·
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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums