469,947 Members | 2,176 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Update List Box data

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
3 1603
MMcCarthy
14,534 Expert Mod 8TB
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
Thank you for the help. It works like a charm!
May 6 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
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.

Similar topics

8 posts views Thread by Lauren Quantrell | last post: by
5 posts views Thread by Louis LeBlanc | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.