Cascading Combo requery problem

[HockeyNut]

Hi,
I've read some about cascading combo's and wanted to use it. However, I've hit a problem, it works first time around, but. If I re-select the first combo box and choose a different option, then it doesn't subsequently update (requery) the next (sub category) combo box.

The code I found on one of the searches I did on "Cascading combo"'s is this.


Option Compare Database

Private Sub TypeID_AfterUpdate()

Me.TypeID.Requery

End Sub


I tried adding this to various events on the 2nd combo, such as "Before update" and "on click". But all still to no avail.

Is this just the way cascading combo's work, or am I missing some way of getting around this problem?

Kind regards,

 

[Mile-O]

Click the smilie:

 

[HockeyNut]

Thanks Mile