Querying a database with optuion buttons

[MattB]

Hi all

you will have to excuse my lack of of knowledge but I am trying to query a few tables by the use of a combo box and a set of three option buttons. The form will search my tables using the value in the combo box and selected option. The problem I am having is with the option buttons and knowing how to query my tables using them.

My problem is the option buttons don't refer to a single record. for example
the first option will be current which I want to select "active" and "possible" in out of one of my tables. The second option button "Cleared" will select only "Cleared" from the table and lastly the option "All" will select all records.

I have tried for a while to get my head around it and I am still unsure of the how to go about it. Any help that anyone could give me would be greatly appreciated

Cheers Matt

[llkhoutx]

Use an option group for you option buttons which simplifies the criteria of your query.