I have a query the requires a field from either one of two forms that opens a third form. The criteria that I currently have:
[Forms]![frmPeopleConCust]![JobID] Or [Forms]![frmPeople]![JobID]
When either of the two calls the third, the data from the un-opened form is requested. For example, if frmPeopleConCust attempts to open the third form, then the query requests the parameter from "frmPeople".
I would like to run this query regardless of which of the two forms are open.
It appears the "OR" does not work as I precieved it would.
I need help!!!!
[Forms]![frmPeopleConCust]![JobID] Or [Forms]![frmPeople]![JobID]
When either of the two calls the third, the data from the un-opened form is requested. For example, if frmPeopleConCust attempts to open the third form, then the query requests the parameter from "frmPeople".
I would like to run this query regardless of which of the two forms are open.
It appears the "OR" does not work as I precieved it would.
I need help!!!!