Combinationbox defaults to top choice

I've got a form in Access 2003 with a combinationebox with values read from a table ie:

2011-3
2011-2
2011-1
2010-1
2009-1

If I select ie 2011-1, it defaults to 2011-3 after selection...it's driving mad, that I can't figure out what causes this. No underlying code as is causing it, as far as I can see.

please advice
Thanks
Michael
LVL 1
Mik MakConsultantAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
check the rowsource of the combo.
the bound column of the combo must have unique values.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Is .... there any code associated with this combo box?

mx
0
 
Mik MakConsultantAuthor Commented:
Hi Capricorn1

Ahh, exactly ! - thank you for a most speedy response :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.