Combo based query prompts for a value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ToyFixer - 10 Jul 2007 17:18 GMT

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?

Reply to this Message

Klatuu - 10 Jul 2007 18:10 GMT

post the code. can't see it, can't fix it.

Signature

Dave Hargis, Microsoft Access MVP

> 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?

Reply to this Message

Jeff Boyce - 10 Jul 2007 18:19 GMT

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

>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?

Reply to this Message