468,537 Members | 1,926 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,537 developers. It's quick & easy.

help needed to refresh combobox

101 100+
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.
Dec 11 '07 #1
2 2889
puppydogbuddy
1,923 Expert 1GB
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
Dec 14 '07 #2
billa856
101 100+
Thank You for ur reply, but I already got the answer.
Dec 14 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by hasden | last post: by
3 posts views Thread by Rick Shaw | last post: by
1 post views Thread by pointies | last post: by
3 posts views Thread by fran_j_diaz | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.