G
Gibson
I have a query (main query) whose data comes from one table and one query
(data query). In the main query I have criteria such as Forms!frm1!Field1 so
it only retrieves data for the contents of Field1. The problem is the data
query needs to be filtered the same way but when I put the identical
criteria in the data query and try to open the form I receive an error
saying "No value given for one or more required parameters." If I take the
criteria out of the data query then the form opens fine but of course the
data is not what I want.
Any way to have the criteria in both queries and supply them when opening th
form?
(data query). In the main query I have criteria such as Forms!frm1!Field1 so
it only retrieves data for the contents of Field1. The problem is the data
query needs to be filtered the same way but when I put the identical
criteria in the data query and try to open the form I receive an error
saying "No value given for one or more required parameters." If I take the
criteria out of the data query then the form opens fine but of course the
data is not what I want.
Any way to have the criteria in both queries and supply them when opening th
form?