cascading combo won't work (yes I have tried ...)

[pink_sean]

Hi, new to Access but quite an experienced developer which makes this all the more annoying.
I have a cascading combo box which won't refresh the dependant combo box values when the first has been updated i.e. the requery event won't run in the after update event.
Bemused by this I downloaded an example form from this forum pasted it into my db - code was identical etc and it worked .... until as an experiment I copied the two fields into my form when it didn't refresh. Thus, I'm thinking it must be something on the form properties? The form does have a subform embedded on it but the fields aren't related to anything in it (it's basically an order form with Staff and Dept being the connected combos and the subform is the order detail lines.
Am I missing something?
Thanks in advance for your help ...
PS I've also tried naming the form in the requery as well as just me.fieldname.requery

 

[AccessMSSQL]

You'd have to post some code for us to determine what the problem is. Maybe there is some other event in your form that is kicking off after the requery that is clearing those? Not sure. Can you post some examples and code?