combo box selected records

[reneets1]

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!

 

[MGFoster]

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!

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

That's a strange one.

Have you changed the other properties?

course name, course id, start date

Bound Column - is it the course ID column? If so you must change its
number from 1 to 2 now.

Column Widths - is the ID column shown? Make sure all widths are wide
enough to show the data for each column. Something like:

2";0";1" - the 0" will hide the course ID

Is there an AfterUpdate or other event procedure that changes the value
of the ComboBox when the focus changes?

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSqqihIechKqOuFEgEQLF4gCfcJ3ncJLJwV9hILhBWWy0Mihz+SMAn0H2
sUN4jQsBwTvgQ7xx43UylN9k
=4q3G
-----END PGP SIGNATURE-----

 

[reneets1]

Yes, thank you! It was the bound column property that needed to be changed.