Combo box depending on combo box in continuous subform

  • Thread starter Thread starter XMan
  • Start date Start date
X

XMan

I'm not sure this one has been asked a million times but I need an example
for the
trick.
ComboBox2 query depends on ComboBox1 selected value.
ComboBox1 is Customer Class: A, B, C
ComboBox2 is Customer Name. These belong to selected Class.

Two combo boxes in a continous subform.

TIA.
 
put this code in the GotFocus event of the 2nd combobox

combobox1.rowsource = "Select * from table Where field = '" &
me.combobox2.value & "'"

hth

Al
 
Back
Top