Access ComboBox showing list based on other ComboBox

Murray Brown
Murray Brown used Ask the Experts™
on
Hi

I am using the following query to get all the Action Types in a ComboBox when the user selects an Arm Type in the ComboBox above but for some reason it isn't working

1
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
Are you requerying the 2nd combo in the AfterUpdate of the 1st combo and in the forms OnCurrent events?

 You could also use the got focus event of the 2nd combo along with OnCurrent of the form, but the first makes more sense.

  Also in the query above, is the ArmType you are filtering on the bound value for the 1st combo?

Jim.
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thanks very much Jim. Appreciate the help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial