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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Microsoft access database(creating a search engine form) 0
Searching with a text box 3
Search Form - to search for files on pc 1
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Access 2010 0
create search form 1
simple question about preforming a search 6
Search Form 2

Back
Top