Option Box question

[SteveGr]

I can't seem to understand how you set the properties for an Option button group.
I have fields in my tables that are either a "1" or "2", and I would like to query all records with 1s or 2s threw an option boxs on my main form. Thus selecting option button 1 or option button 2 to query records.

Thanks, Steve

 

[Jon K]

The easiest way is to create the option group with a wizard (press in the Control Wizards button before placing the Option Group on the form.)

Then in the query, reference the Option Group name (e.g. Frame0) not the Option Button names as follows:-

SELECT *
FROM TableName
WHERE Fieldname=forms!FormName!Frame0;

 

[SteveGr]

But what if I don't want to pull from a table. I have two tables that I combine to get all data from using a Union query.

I tried using:

Select*
From Qry_Combine_Tables
Where Fieldname=forms!Formname!FrameID:

But it doesn't work. Can someone give me a hint at what I am doing wrong?
Thanks, Steve