98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Dynamic listbox
Dynamic listbox
Resolved · Low Priority · Version 2007
Fri 3 Jun 2011, 12:42
Edited on Fri 3 Jun 2011, 12:44Delegate Robert said...
Robert has attended:
Access Advanced course
Dynamic listbox
Is it possible to dynamically change the values in a listbox based on the value selected in another listbox in the same form?
What I want to do is to be able to select a sub-section in list 2 after first selecting the main section in list 1.
Any help greatly appreciated.
Mon 6 Jun 2011, 10:10Trainer Anthony said...
RE: Dynamic listbox
Hi Robert, thanks for your query. It is possible, but you'll need to do it in VBA. What you're trying to do is capture the event that occurs when you choose an option in the first listbox, and use that to trigger the population of the second.
Hope this helps,
Anthony
Mon 6 Jun 2011, 12:39Delegate Robert said...
RE: Dynamic listbox
Thanks Anthony.
I put an 'on click' event on the first listbox that requeried the second listbox. This seemed to work ok because the selection criteria of the second listbox was based on the selected value in the first one.
Mon 6 Jun 2011, 12:41Trainer Anthony said...
RE: Dynamic listbox
Excellent! Glad it worked!
Anthony
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Prefixed AutonumberingWhen using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter. |
