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

Update List Box data

P: 7
Ok I have two list boxes. One list box gets it values from a list I typed in. It is used in a query that populates the list in List box2. It works fine but only for one time. If I make another selection in list box 1 it never updates list box 2 it just keeps the same values. Is there a way to update that list everytime I change the value in list box 1?
May 6 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Ok I have two list boxes. One list box gets it values from a list I typed in. It is used in a query that populates the list in List box2. It works fine but only for one time. If I make another selection in list box 1 it never updates list box 2 it just keeps the same values. Is there a way to update that list everytime I change the value in list box 1?
In the after update event of Listbox1 you have to put the following.

Expand|Select|Wrap|Line Numbers
  1. Me![Listbox 2].Requery
May 6 '07 #2

P: 7
Thank you for the help. It works like a charm!
May 6 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Thank you for the help. It works like a charm!
You're welcome.
May 6 '07 #4

Post your reply

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