using the acCmdFind

[techkenny1]

Hi all,
On text boxes I use the following code on a on click event to do a search
DoCmd.RunCommand acCmdFind

However at times the following error comes up.
"You can'tuse Find or Replace now"
*The fields are not searchable due to one of the following
*The fields are controls
*The fields have no data
*There are no fields to search
The only way to do a search is to close the search form down and then reopen it.
Is the code I use right or is there another way of doing a search.

Many thanks

 

[ProgramError]

There are many way to search, if you do a search on here you will find them.

But to get you in the mood, create a query with search criteria below, on the field you wish to search.

like "*" & [nameofsearchtextbox] & "*"

Use it as the record source of a form.

create a new search form with a textbox (which in this case I called nameofsearchtextbox) and either open the search result for you previously created with the afterupdate event of the textbox or use a button to open the results form.

Hope that helps.


Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.