Hello! I've done my share of searching on this topic, but I haven't made any progress with any of the examples I've found. I would like to incorporate a multi field search option for the users of my db. I'm really lost on this one, please help.
Search Option
- Thread starter TheDeal56
- Start date
Well from what you provided there are not any forms, but this is what you would want in a form. When you use the "Command Button" tool there is an option record navigation> find record, this will open a the Access Find and Replace dialog box which is a very simple way of doing it. It will allow you to search multiple fields but only one at a time.
If you wanted to search multiple fields at once you would need to create a form with a text box that would be your search word. Then create a query that searched all the multiple fields that you want to search with a "Criteria" of the value of that text box. Although since you want "or" you should probably put them all under one column. The build function will help you out on that.
Good luck.
If you wanted to search multiple fields at once you would need to create a form with a text box that would be your search word. Then create a query that searched all the multiple fields that you want to search with a "Criteria" of the value of that text box. Although since you want "or" you should probably put them all under one column. The build function will help you out on that.
Good luck.
Luddite Lad
Registered User.
- Local time
- Tomorrow, 00:30
- Joined
- Aug 23, 2005
- Messages
- 177
I'll look harder into that post tomorrow. Thanks a lot for linking that. I figured this would be an easy, frequently used, search type. Apparently it's a bit tougher than I originally thought 
. Thanks again; you guys are awesome.
. Thanks again; you guys are awesome.That's not exactly the type of search I was talking about, but that one is really cool. I would like to have that at some point, but all I need for now is just a search button that runs the user's input as a query. Thanks.
