3 combo boxes

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

Carl Rapson

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
 

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

Similar Threads

Combo box form 1
Synchronize combo boxes 2
Combo Box, Unbound Text Boxes 2
Combo Boxes 6
Problem: Combo boxes self-populating 11
combo box selection will not populate query correctly 1
Looking for a recent thread on multple combo boxes 7
Cascading Combo Boxes in Main Form 8

Top