BruceWaller
New Member
- Joined
- Jul 12, 2011
- Messages
- 9
I am working on a form that I need to be able to search based on two fields located in separate tables. The tables are joined in a one to many relationship. Do I have to start with a query?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Simultaneous search of two fields which are in separate tables.
- Thread starter BruceWaller
- Start date
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
Do you want to drill down to a specific record? If you do, a common way to do that is to use combo (drop-down) boxes in the header of the form.
Search this forum for cascading combo or cascading listbox -- there are plenty of examples.
Denis
Search this forum for cascading combo or cascading listbox -- there are plenty of examples.
Denis
Upvote
0
Similar threads
- Solved
