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
 
You must log in or register to reply here.

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

Query with results in a value list from a combo box? 1
Using combo box(s) to create a query 1
Exicute an append query in an after update event 0
Query Update based on Combo Boxes 3
Combo Boxes 2
Access Control on subform / combo box requesting parameter 0
Basing a query on the selection in a Combo box parameter 2
Combo Box in a Query 3

Back
Top