Forum home » Delegate support and help forum » Microsoft Access Training and help » Dynamic listbox
|
|
|
The UK's most regular 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. |
Dynamic listbox
Resolved · Low Priority · Version 2007
Reply 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.
For upcoming training course dates see: Pricing & availability
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
Reply 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.
RE: Dynamic listbox
Excellent! Glad it worked!
Anthony
|