Combo box prob - little urgent

[pratim09]

I have 2 combobox in a form . cmb1 and cmb2 . On the cmb1 on change event i am populating the values of cmb2 according to sql query in code. First time the cmb2 values populates correctly .Also on change property of cmb2 populates other values in the form.



The problem is 2nd time when I select cmb1 for some other value the cmb2 retains the values of the first cmb1 search along with the new ones for the recent cmb1 value.Ideally it should show the new values only.

How do i get rid of these. Attached is a sample.

[free_style]

I have 2 combobox in a form . cmb1 and cmb2 . On the cmb1 on change event i am populating the values of cmb2 according to sql query in code. First time the cmb2 values populates correctly .Also on change property of cmb2 populates other values in the form.

The problem is 2nd time when I select cmb1 for some other value the cmb2 retains the values of the first cmb1 search along with the new ones for the recent cmb1 value.Ideally it should show the new values only.

How do i get rid of these. Attached is a sample.

Hello friend,

The problem is that you have to make Requery of the form you use.
Try to add event "After update" on the first combo box - cmb1:

Me.Requery

Then everything should be work fine!

Best wishes

[pratim09]

Thanks for the reply .I tried doing a requery on the form on the after update event of cmbbox 1 but its still not working.The previous values are still showing.I have attached my sample app in the previous post ,if u need.