Depedent combo box

[dealwi8me]

I have a combo box that is based on another combo box (with a query). When i make a choice in combo1 i get the appropriate value on combo2 but when i change the combo1 value i don't get the changes on combo2.

For example i have combo1 with values value1,value2 and on combo2 i have for combo1 the values val1_1, val1_2 for value2 val2_1,val2_2.
I choose the value1 on combo1 and i get the val1_1, val1_2 on combo2. If i change the value on combo1 to value2 then i still get the val1_1, val1_2 on combo2.

Any suggestion how to solve this problem an get the correct dependent values?

Thank you in advance

 

[rblair11]

Try adding the following code to the afterupdate event of combo 1:

me.combo2.requery

This is my first attempt at trying to help someone on this forum so I hope I'm not completly off base here

 

[ocp&mcsd]

Yes, Mr. rblair11, your suggestion could be the solution...

Let's see....

 

[dealwi8me]

That works just fine!

Thank you for helping me

 

[ocp&mcsd]

Hi Mr. dealwi8me
I found an example expalin what you wanted....
C it f u like ......

Credit: http://www.databasedev.co.uk

Thanks & Regards,