dropdown data for form fill-in - query problem

[Cowtoon]

I've created a form and it includes selecting data from a dropdown box, and
it populates my table. However, when I run a query, it won't pick up the
record that has the data criteria from the "dropdown" list.
Help.

 

[Guest]

Just a guess, but it sounds to me like you may have one of those evil table
lookups defined at the table or query level. If this is the case, the value
being stored in the table may not be as it appears. Please see the 2nd
Commandment of Access here:

The Ten Commandments of Access
http://www.mvps.org/access/tencommandments.htm

If you see a combo box type dropdown when viewing a table or a query based
on the table, then you likely have a table lookup defined.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Cowtoon]

Thanks for the response Tom. I'll check it out.
Diana

"Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message
Just a guess, but it sounds to me like you may have one of those evil table
lookups defined at the table or query level. If this is the case, the value
being stored in the table may not be as it appears. Please see the 2nd
Commandment of Access here:

The Ten Commandments of Access
http://www.mvps.org/access/tencommandments.htm

If you see a combo box type dropdown when viewing a table or a query based
on the table, then you likely have a table lookup defined.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________