combo boxes on queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Some of my combo boxes aren't working on queries. They wont let me select
any of the options. One example is that i have a status as client drop down
box. it is set to "new", and on the table i can change it to "up to date."
however, i cannot change it on the account summary query. i have made sure
that all forms allow edits and deletions. I find it easiest to use queries
as my control source, but i cant do that if my combo boxes dont work
correctly. i am using access 2003. PLEASE HELP ME. you'll be my hero.
 
Is there a chance your underlying table(s) have a "lookup" datatype field?
This could cause confusion in your queries, since what is stored and what is
displayed don't match when you use the "lookup" datatype.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top