Combo based query prompts for a value

T

ToyFixer

I have a set of combo boxes to filter through to find records
However, one of the combo boxes prompts me for a value. when I enter a valid
value the query works fine. Why doesn't it get the value from the previous
one? under what circumstances will this happen?
 
J

Jeff Boyce

If your query doesn't recognize the name of the prompt/source, it will
prompt YOU for the value. The first place I would look would be to see if
there's a spelling difference between the form/combo box name and the
selection criterion for that one.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Combo box 0
Prompted for a value for combo box value 1
Update a an unbound combo box 1
Prompt for a subform text field 2
Controlling a list box population based on combo boxes 1
combo box based on a combo box 1
Form -> Combo to a SubForm 3
2007 Multi Value Check Box Lists 1

Top