Forms for searching

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a way to use a form for searching in a special field. It has to work
like this:
The user must enter a number/text into a field and then the database has to
search for this number/text. Just like the normal serach function in Access,
but I need it to run by a macro. I have tried but it doesnt sort the records,
so I just get the ones with the specific number/text.
I have also tried to create a query, but it doesnt work properly.
Can anyone help me with this.
 
You need to give details of what your results are.
I have tried but it doesnt sort the records,
Click to expand...
What are you using for display?
so I just get the ones with the specific number/text.
Click to expand...
Use this in the criteria of the query --
Like "*" & [Forms]![YourForm]![YourTextBox] & "*"
I have also tried to create a query, but it doesnt work properly.
Click to expand...
This does not tell what is not working, what the error is, what is working.
 
Poul posted: "I need a way to use a form for searching in a special
field. It has to work like this: The user must enter a number/text into
a field and then the database has to search for this number/text. Just
like the normal serach function in Access, but I need it to run by a
macro. I have tried but it doesnt sort the records..."
~~~~~~~~~~~~~~~~~~~~~~~~~~
What do you mean when you say you "need it to run by a macro". Where
would the macro fit into the steps you describe?

Could you not simply create your form and place a combo box search tool
on it? The list displayed by the combo box could be sorted, too. It
seems to me that it would fit your needs, if you set it up properly...

hth-

Betsy
 
Back
Top