Combo Box selection disappearing on new record and change of option selection

[EmmA]

Hi all,

I have a combo box on a main form that is filtered through
the selection of an option in an option group also on the
same main form. The filter works great, and I can make
selections from my combo box. However, when I go to enter
a new record and change the option selection and then I
move to a previous record, my selection in the combo box
of the previous record is gone. If I click on a different
selection in the option group on the previously entered
record and then click on the correct selection in the
option group, the combo box selection reappears.

So I know the records are being saved correctly but how do
I keep the combo box selection in previous records after I
have moved to a new record and changed the Option group
selection in the new record?

Emma Aumack

 

[Alicia]

My thought is to try to update the Option selection in
the on Current event of the form. If I understand, the
information needed to update is being stored correctly
for the records. So just use the on current event to
reset the option selection each time you change records
then the rest will update automatically. I think.

 

[Malcolm Cook]

soudns good.

only - don't expect comboboxes whose content is dependent on other fields in
the current record to display correctly in datasheet (or continuous form)
view. THere is only one combobox on your form - each record is viewing its
underlying data though it - and it just wont work.

Good luck

-Malcolm