Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 09-09-2019, 06:38 AM   #1
Ceebee86
Newly Registered User
 
Join Date: Sep 2019
Posts: 25
Thanks: 5
Thanked 0 Times in 0 Posts
Ceebee86 is on a distinguished road
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.

Now...

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?

Ceebee86 is offline   Reply With Quote
 

Tags
macro actions , macro builder

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Question? Querying a table to create a new report smelff Queries 1 04-15-2010 11:09 AM
querying SQL server - a problem jay_l_a Queries 4 09-10-2008 10:52 AM
A Very Odd Querying Problem Mithander Queries 8 07-07-2008 05:29 AM
querying an empty date field with IsNull problem alant37 Queries 4 06-16-2005 02:37 AM
Querying with Date Format Problem (Again) Ally Queries 6 06-19-2002 01:44 AM




All times are GMT -8. The time now is 08:17 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World