Search Form

[Richard]

I have a query that I am using to search my database but
would like to do is have 3 option buttons [EqupID],
[Merchandise],[Account#] as the options and have a Text
Box where you enter the search. I would like to have the
Text Box inactive until an option is selected, I know you
use the True and False but I don't know how to do this.
Thank you in advance.

 

[Kelvin]

What you want is the Visbile property of the text box. You said you are
using option buttons and not an option group so I am assuming you have code
to turn the other options off when you select one. Try.

Me.NameOfTextbox.Visible = Me.NameOfOptionButton

Kelvin

 

[Con Giacomini]

If you are using Access 2000 or later you can use the 'Filter by Form'
technique. This is like Query by Form without the query.

Con Giacomini