Search Using Radio Buttons

I'm have trouble working out how to use radio buttons with the Search SB.

Basically I have a form with three radio buttons named "status", one labeled "Used" one labeled "Not Used" and one labeled "All". All three of these will check the one database field, "fldInvNum". If the user selects "Used" it checks for a null value, if the user selects "Not Used" it checks the same field for not null and if the user selects "All" then it returns all records.

When adding the parameters to the Search SB, under filter type, there doesn't seem to be an option for a radio button.

There is no radio button option in the search server behavior. In this case, I would recommend using two checkboxes instead of the radio buttons. The two checkboxes would be one for used and one for not used. You would then select check as the type and set the checked value for each of the checkboxes separately.

Thanks for the reply Jimmy.

This almost works, I have added two checkboxes one named "used" and one named "not_used" and if you select one or the other you get the disired results. The problem is if you select both. I would want this to then display all records but it doesn't display any records.

Did you set values for checked and unchecked for each or did you leave the unchecked blank?

I wasn't aware you could set a value for "unchecked" using a checkbox. Anyway the checked values are set to "Used" and "Not" respectively.