Changing combobox lookups

  • Thread starter Thread starter Larry Charlton
  • Start date Start date
L

Larry Charlton

I have a form with two combo-boxes, say MasterType and SubType.
MasterType has the values A and B. SubType has the values:
A 1
A 2
B X
B Y

I put code in the OnCurrent and in MasterType's OnChange event to Requery
the SubType. This works fine for data entry, but in a datasheet view, when
I'm on MasterType A, All the master type B records go blank. When I navigate
to a type B record, all their sub types show but the Master Type A Sub Type
records go blank.

How to a make depenedant combo-boxes work in a datasheet?
 
The issue is that you're trying to change the RowSource for a combo box, so
it impacts every instance of that combo box on the form.

You should be able to use Sandra's approach of superimposing a text box over
the combo box to display the actual value. After all, you only need the
combo box on the current row, not on any of the other ones.
 
Back
Top