Parameter query behavior in form vs. subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using a parameter query as a source for combo boxes in a subform, the
data displayed being based on other combo boxes. I have this working
beautifully when I only have the subform (sbfLocation) opened, but when I
open the form (frmItem), the query prompts me for the parameters.

Is this a problem with how I am referencing my combo boxes in my parameter
query? My queries look like this:

PARAMETERS Forms!sbfLocation!cboRoom Text (255);
...
WHERE (((Locations.Room)=Forms!sbfLocation!cboRoom));

Anyone know what I'm doing wrong?
 
Back
Top