Create a search form

[mike]

Hi all,

I just want to know if I can get the value in the text box
when a command button is clicked and pass the value to
the list box, so the list box can do a query base on the
value gotten from the text box. What I mean is that,
when I enter someting in a text box and press a command
button, that command button takes the value from the text
box and pass the value to the list box. The list box then
take that value and perform a query and displayed the
result within it. Is it possilbe to do it??
Any suggestion??

Thanks for the help...

mike


..

 

[Dan Artuso]

Hi,
What you want is possible.
The value from the text box would be passed as a parameter
to a query, you can't 'pass it to the list box', that makes no sense.
The list box would be based on the query so that when you re-query
it, it would display the value(s) you want from the query.

The easiest way to 'pass the parameter' would be to put a reference
to the text box in the criteria of some field in your query:

Forms!yourForm!yourTextBox

 

[Andy]

Mike;

I found a lot of useful information at:

http://www.mvps.org/access

Including how to add a search form to a database:

http://www.mvps.org/access/forms/frm0045.htm

Andy