combo box selected records



PLEASE HELP! I have a combo box that pulls class data from a query: course
ID, course name, and start date, in that order. Currently when the user
makes a selection there is no issue. I want to change the query so that the
first field is course name, then course id and start date. When I make this
change in the query and the user selects the course they want, after tabbing
out of the field Access changes their selection to the first date for that
particular course. For instance, we have a MUSE course with 5 different
dates, jan, apr, may, june, july. They want to select the july class but the
combo box keeps defaulting it back to the jan class which is the first class
for that course. This only happens when I try to flip those two fields
around in the query and I can't figure out why this is happening. Any help
is greatly appreciated!


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