Option Button uses an SQL statement

[LATECHmatt05]

Hello,

I have a problem I have three option buttons linked to three different yes/no fields that I want to have a query done on. I don't know the syntax for option buttons, but I would like to try to allow the user to pick one of the the three and link to an or statement.

In other words lets say that you have three buttons.

chips fries onion rings

if I check fries I want to look only for fry records, but if I pick onion rings and chips I want to look for records with both in them. Thanks in advance

Matthew

 

[CajunCenturion]

Having three options linked to three different yes/no fields is best accomplished with three check boxes, not option buttons. Option buttons normally are used where you cannot select more than one option. In this case, you should be using checkboxes since you can pick more than one.

Good Luck
--------------
To get the most from your Tek-Tips experience, please read FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein