I have 3 queries that pull from 3 dfferent tables. All 3 tables contain a field called Acct but the other fields in the 3 tables are different. What I would like is to have a form field that the user can input an account number and depending on which query the account number is in, that query and result will display. I have been trying the dlookup function but can't seem to get the coding down. Also, if the account number is not in any query I would like a message box to display saying it can't be found. Thanks for any help!
Open Query if field is true
- Thread starter jamphan
- Start date
- Local time
- Today, 13:19
- Joined
- Feb 28, 2001
- Messages
- 30,501
Please do not multi-post the same question. You can delete the extras since you posted them.
