Macro problem - Re querying
Hi Access world!
I'm a new user, and a bit of an Access novice. I've created a form, and on this form there's a side bar. It contains two radio buttons, a list of hyper links, and a sub form that displays data.
When you select one of the radio buttons (Active or Not Active) and click one of the hyper links. An embedded Macro looks at which radio button has been selected, and then runs a Filter on the sub form, depending on the value of the radio button box. This all works quite well.
If I have selected Active, clicked a link to display Active data, and it displays....But now, I click the 'Not active' radio button.
How do I get THAT event of clicking not active, to change the Filter to its opposite brother, and refresh the sub form query?