Query Parameter Problem

[cdaz]

This is my 1st post so hope I do it right...

I have a Master Table where fields are populated using a drop down box that is based on a Table with 2 fields: ID and Day of the Week.

When I query the Master Table and use the parameter [Enter Day of Week], the query only works if I enter the ID rather than the Day of the Week.

I think I've read somethign about this but I can't remember what and can't find anything.

THanks for the help!

 

[pbaldy]

I moved your thread to a more appropriate forum. Sounds like you've used a lookup field:

http://access.mvps.org/access/lookupfields.htm

which I wouldn't. In any case, I'd use a form to gather user input, which would let you use a combo box.

 

[cdaz]

Thanks so much. Your reply pointed me in the right direction. I was using a form to enter the data but I had incorrectly established Lookups on both the Table and the Form. Anyway, everythingi s fixed and working now.

I really appreciated your prompt reply!

 

[pbaldy]

Happy to help, and welcome to the site by the way!