3 cascading combo box

[rexb]

Hi,

I've been trying to create a cascading combo which has 3 combo boxes but I am getting nowhere. Can somebody help me please.

The form "frmCommunicationInfo" has Category, Make and Model which is a combo box that I would like to display the data on the first combo box which would relate to the 2nd and the 2nd would relate to the 3rd. I've attached my database (part of it).

Hope somebody would help me.

Thank you in advance.

 

[pbaldy]

In your code:

Private Sub cbo_CommCat_AfterUpdate()
  cbo_CommCat.Requery
End Sub

You're requerying the combo just changed, rather than the next one in line (make in this case).

 

[rexb]

In your code:

Private Sub cbo_CommCat_AfterUpdate()
  cbo_CommCat.Requery
End Sub

You're requerying the combo just changed, rather than the next one in line (make in this case).

Hi,

I don't seem to understand?

 

[pbaldy]

Looking just at the first 2 for now, you have 2 combos, "A" and "B". The selections in "B" depend on the selection made in "A". In your code, when "A" changes, you want to requery "B", as it's the one whose selections will change. You're requerying "A". Here's a sample db:

http://www.baldyweb.com/CascadingCombo.htm

 

[rexb]

Looking just at the first 2 for now, you have 2 combos, "A" and "B". The selections in "B" depend on the selection made in "A". In your code, when "A" changes, you want to requery "B", as it's the one whose selections will change. You're requerying "A". Here's a sample db:

http://www.baldyweb.com/CascadingCombo.htm

Thank you I tried but I can only do two combo box. I'll just try another solution to my problem. Thank you for your time.