How can I trap an error when using a query to search ?

[testkitt2]

Good eve to all...

I have a query that uses the following criteria:

Like [Enter the first few characters to search by: ] & "*"

the above allows the user the flexibility of searching with only the first few characters. But if you enter invalid characters the query will return a page with blank results.
In a report you could trap this error with the following event.

On No Data (event)

MsgBox "There is no data for this category,.... Canceling report..."
    Cancel = -1

with the above the user will be alerted of his error.

Sorry for being long winded.... What I need if possible is something I could use to trap a wild card search error in a query. So that when a user enters an invalid wild card he/she will presented with a msg and the search cancelled.

Any help will be greatly appreciated.

Thank you
JZ


Testkitt2

 

[ZmrAbdulla]

If you are entering the search criteria into a field on a form then you can control the key strokes as you wish. See thread700-1090566 for a sample code.

________________________________________
Zameer Abdulla
Visit Me
If you have never been hated by your child, you have never been a parent.[/color]