By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,889 Members | 1,297 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,889 IT Pros & Developers. It's quick & easy.

help needed to refresh combobox

P: 101
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 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
So it will just remove previous value from combobox and refresh the combobox.

Dec 11 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,923

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

P: 101
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.