Want to use a form combo pick for a query for all the records 1

[cimoli]

I have a form where I pick a ResortID2. Then I hit a button to run a Query.
There is no ResortID2 in the Qry. I need ResortID2 for each record to find some info.
The query has criteria. But each record in the set would use the same ResortID2.

In the Qry, I tried to make a field as such :
ResortID2: [forms]![frmOtherReports]![cboResortID2]

I was hoping that each record in the qry would use the same resortID2
based on this form field.

Any ideas? Thanks much.

 

[PHV]

There is no ResortID2 in the Qry
So, what do you want really ????

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886