help needed to refresh combobox

[billa856]

Hi,
My project is in MS Access.
In that I have one Form in which I have some Comboboxes.
1st one is Independent,
2nd one is dependent on first one,
3rd one is dependent on 1st and 2nd both.
After I load the form when I select an item from 1st one it will generate list for 2nd one, then I select an item from 2nd one it will generate list for 3nd one. Uptil this, all r done well.
But after these selection if I change the selection of 1st combobx then it will generate new list for 2nd one.but when I gotfocus on 2nd one after selecting an item from 1st one it have to delete the previous selection from combobox.so it have to show me blank combobox again same as when I load the form at that time all comboboxes are blank.
So it means I want to refresh the combobox only.
I can get new list whenever I select new item from 1st combobox.for that i used PalletNo_combo.Requery in afterupdate event of 1st combobox.
after that or before that I want to put thing like this
ItemNo_combo.Refresh
So it will just remove previous value from combobox and refresh the combobox.

Thanks.

[puppydogbuddy]

Hi,

Put the following as the first line of your after update code of the first combo box, so that when the combobox is requeried, the previous selected value will be removed.

ItemNo_combo = Null

[billa856]

Thank You for ur reply, but I already got the answer.