brucesilvers
Registered User.
- Local time
- Yesterday, 22:40
- Joined
- Aug 4, 2000
- Messages
- 70
Can I use the field value from one form Or from a different form (whichever is open at the time) as a criteria for one of the fields in a query?
I'd like to set the criteria for one of the query fields as follows:
Forms![FormA]![TheField] Or Forms![FormB]![FieldName]
I've already tried it that way, and even when I turn off warnings in the controlling macro or code, a dialogue box pops up asking for the field value for the form that Isn't open.
Is it possible to do this without the dialogue box popping up? (I'm trying to automate the printing of a report either many times for all customers or just one time for a single, prompted customer, depending on the user's preference.)
Thanks for any help you can provide!!!
I'd like to set the criteria for one of the query fields as follows:
Forms![FormA]![TheField] Or Forms![FormB]![FieldName]
I've already tried it that way, and even when I turn off warnings in the controlling macro or code, a dialogue box pops up asking for the field value for the form that Isn't open.
Is it possible to do this without the dialogue box popping up? (I'm trying to automate the printing of a report either many times for all customers or just one time for a single, prompted customer, depending on the user's preference.)
Thanks for any help you can provide!!!
