I have a form that has an option group with 2 radio buttons, then below the option group there are fields with combo boxes where the user can select various codes from the dropdowns.

These codes can exist as data in columns of TABLE1 or TABLE2. The codes are all housed in the same code table and the code table doesn't have a column which specifies that a code is a "TABLE1" code or "TABLE2" code. So, yes, theoretically a user could enter a "TABLE1" type code in "TABLE2" and vice versa, but that's an integrity issue that's seperate from this problem.

What I need to do is be able to return rows from a query depending upon which radio button is selected in the form. BUT THE RADIO BUTTON DICTATES THE JOIN.

Thus, if they select button1, then I need my query to join against TABLE1, and if they select button2, I need my query to join against TABLE2.

The query will be executed as a Click Event for a button on the form. I do not want to create two seperate buttons to invoke each query seperately since it's not as clean an approach.

Is what I want to do possible in Access? (running Access 2003)

All responses appreciated. Thanks!

I do not see an easy way in Access to change the table where u run ur query. Making a second query, one for each radio button, would not be possible?
Trully Penta.

Suppose you have the option group with the two radio buttons. Suppose the option group is called grpCodeGroup and the two options buttons are called optTable1 and optTable2. When you click optTable1, then grpCodeGroup will equal 1. When you click optTable2, grpCodeGroup will equal 2. On your option group's AfterUpdate event, you have something like this:


For each row source, change the [Field] and WHERE clause to specify what you want.




Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division