Combo box depending on combo box in continuous subform

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.
 
N

Newbie

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

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

hth

Al
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top