Changing control Rowsource when switching records

[Pason]

I'm relatively new to Access to I hope this makes sense...

I have a bound form with 2 combo boxes. The rowsource of the 2nd combo
box depends on the selection in the 1st combo box, which has the same
rowsource regardless of the record.

The problem occurs when I switch between records. I reinitialize the
rowsource in the On Current event, but the 2nd combobox selection then
changes to the first one in the list. After I reset the rowsource I
need to reset the value to the value in the table.

J

 

[Pason]

I'm relatively new to Access to I hope this makes sense...

I have a bound form with 2 combo boxes. The rowsource of the 2nd combo
box depends on the selection in the 1st combo box, which has the same
rowsource regardless of the record.

The problem occurs when I switch between records. I reinitialize the
rowsource in the On Current event, but the . After I reset the rowsource I
need to reset the value to the value in the table.

J

I figured it out..."2nd combobox selection then
changes to the first one in the list" doesn't actually happen.