Create a search form

  • Thread starter Thread starter mike
  • Start date Start date
M

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


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