Parameter query behavior in form vs. subform

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filter query on combo box in a continuous subform 0
Access Control on subform / combo box requesting parameter 0
Enter Parameter Value on a subform 15
Nested Subform load order - Parameter prompts I shouldn't get 4
help with subforms and combo boxes please!! 4
Dependant combo box in subform 2
Parameter Value error in a Subform 0
Several combo boxes (with "All" option included) in a form/subform 4

Top