CODEWITHSUNDEEP
ms-accesscombobox
Chelle
Chelle

Reputation: 177

Access 2007 selected value on combobox not displaying on more than one record

I have a ComboBox that displays a list of major occupations; when an occupation is selected its corresponding code is saved to a TextBox beside it. A further ComboBox for minor occupations is next, and the options shown in it are dependent on the option selected in the first ComboBox. As for the first, when a minor occupation is selected its code is saved to a linked TextBox. The selection and Requery for the second ComboBox was working fine, but now as you move from record to record on the form, the second ComboBox is blank although the TextBox is showing the code that was saved when the initial selection was made. So whichever record had the occupation selected most recently has both its ComboBoxes filled, but the previous records have only the first filled. Any ideas?

Upvotes: 1

Views: 956

Answers (1)

ChrisPadgham
ChrisPadgham

Reputation: 870

you need to put some code in the On Current event of the form to requery the second combo box

Upvotes: 0

Related Questions