how to created afterupdate event

[Brigitt]

I am quite new in access, would like to ask for your help in the following.
I am now building a form, I have/had to set up many combo boxes to display many types of selections.
In from view, when I select from Combo1 the customer categoryX, than only those customers which belong to customer categoryX will be shown in Combo2. this is ok. BUT if I choose an other customer category, the same customers (belonging to the previous category) still visible. I go to desing view, and back again form view, it is updated than. I know I should use afterupdate event, but I do not know how.
any help appreciated!


Thanks!

[TheShabz]

Go the properties of Combo1. in the events tab click the ... next to AfterUpdate. Choose Code builder.

enter in, between the Private Sub Combo1_AfterUpdate and End Sub:

Me.Combo2.Requery

[Brigitt]

It doesn't work unfortunately....I followed steps you said, but nothing happend, combo2 is not updated automatically according to the selection I make in combo1. I need to go back to design view, and back again to form view....then combo2 is updated.
What I am doing wrong?

Thanks