The Rev
Registered User.
- Local time
- Today, 13:57
- Joined
- Jan 15, 2003
- Messages
- 118
I pilfered the code from this thread:
And removed the logic for trailing blanks because I don't care about them. I built my form and the query exactly as described. It works fine except if no results are returned. If there are no results, I get a Runtime Error 2105; You can't go to the specified record, and the offending line is:
Me.SearchFor.SetFocus
How do I tell the form that if no records are returned, just say "No records returned"?
Thanks again for the assist!!
Dynamically search multiple fields
This DB is a modification of a search tool that was posted in these forums several years ago. The tool allows the user to type text into a text box (the text is matched against any part of a number of fields) with the results being shown dynamically in a list box as the user types. Essentially...
www.access-programmers.co.uk
And removed the logic for trailing blanks because I don't care about them. I built my form and the query exactly as described. It works fine except if no results are returned. If there are no results, I get a Runtime Error 2105; You can't go to the specified record, and the offending line is:
Me.SearchFor.SetFocus
How do I tell the form that if no records are returned, just say "No records returned"?
Thanks again for the assist!!