Refreshing Cascading Combo box Queries

[yanos]

hi,
I have a db which uses the data taken from cboInstructors which is used in a query and a produces a list in cboExpertise. This procedure is repeated from cboInstructors for cboAssessors and then cboIVName.

This subform then shows all the modules each student have taken, who taught it, who assessed and who IV'd it. The problem is when one selection is made all the subsequent choices are the same as the cbo above it, i.e. the queries do not run again when a diferent selection is made in cboInstuctors.

I hope this clear.

Help please.

Iain

 

[twoplustwo]

Requery the 2nd cmb imo

 

[yanos]

Hi,
Thanks for answering.

i have put in the requery bit and the second cbo responds, I have tried to put in statements to to requery the third and fourth cbo's but they do not work.

Cheers again
iain

 

[twoplustwo]

3rd and 4th?

Could you zip and upload an example please?

 

[yanos]

Hi
Here is a zipped version with the corresponding bits in it.

Cheers
iain

 

[twoplustwo]

Bleh that version doesn't work properly

 

[yanos]

We can try again

 

[yanos]

Hi,
I found this 15 pages back the way. Good Stuff.



Private Sub cbo1_AfterUpdate()

Dim varID1 As Variant
Dim varID2 As Variant

Me.cbo2.Requery

varID1 = Me.cbo2.ItemData(0)
Me.cbo2 = varID1

Call cbo2_AfterUpdate

varID2 = Me.cbo3.ItemData(0)
Me.cbo3 = varID2

End Sub