3 combo boxes

  • Thread starter Thread starter gspero
  • Start date Start date
G

gspero

Ok here is my dilemna. i have a form with 3 combo boxes. The first is
a combo box with a name which would populate a list, under this the
second combo box would be poulated with a name from another column,
but has multiple listing, for example, under John, would be six
address, I would then like to choose an address from there, and then
populate the 3rd combo box with a listing of items at that address,
how can this be done? I am very stuck.
 
Where is all of this information coming from? If it's all stored in tables,
then in the AfterUpdate event of the first combo box you would set the
RowSource of the second combo box based on the selection:

cboSecondBox.RowSource = "SELECT ... FROM ... WHERE [Name]='" & cboFirstBox
& "'"

Similar for the third combo box.

Carl Rapson
 
Back
Top