Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
How to call a form from multiple locations in Access 2007?
The question is this. If the look up by name or address, there is an intermediate step because they get a list of similar names and they chose a record which passes the account number to the same screen as the look by account number screen. But the criteria is different. Instead of [FORMS]![frmAcctNumber].[txtAcctNumber] it is now [FORMS]![frmName].[txtAcctNumber] or [FORMS]![frmAddress].[txtAcctNumber] . Right now I have this working by have the different look up methods call different but identical forms that use different queries. This seems like a nightmare to maintain. I tried to have one query that uses OR in the criteria but when I do this, I always get a pop asking for the value from the look ups I'm not using, meaning if I look up by Account Number, the application asks me for the value for Names and Address ([FORMS]![frmName].[txtAcctNumber] or [FORMS]![frmAddress].[txtAcctNumber] ). How do I get around this?