Search Form

  • Thread starter Thread starter Richard
  • Start date Start date
R

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.
 
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
 
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
 
Back
Top