We help IT Professionals succeed at work.

Make connection type values display in a form via mutliple dropdown boxes selection.

456 Views
Last Modified: 2014-05-16
I have an access 2010 DB (attached) that has a main form called "frmclientinfo" with the client data in it and it has a subform with the clients addresses and then another subform that has multiple remote connection types.

I need to figure out how to turn this main form into a form with only 3 dropdown menus on it - one for "Client Name" another for "Client Address" and another for "Connection Type"

The "Connection Type" menu should have the following selection options:

RDP
Gateway Router
ESXI

once a selection is made for each dropdown then i need the subform to only display the values for the appropriate connection type that was selected.

Thanks in advance for your help!
Database1.mdb
Comment
Watch Question

Software Developer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Gozreh has what you're after.

I'd also remind you that EE isn't really a "do this for me" sort of service - we're here to help you with your project, not just do it for you. I'd encourage you to try these things yourself before asking us for help, and when you get stuck come back here with specific questions. For example, in this instance you should have created the form and added your combos, and tried to get them to "cascade" (there are hundreds of postings here on EE regarding cascading combos), and then tried to figure out how to set the Subform Control correctly to show your data.
Dana DIT Consultant
CERTIFIED EXPERT

Author

Commented:
Awesome Gozreh! Thanks you so much! And I was willing to do the work to get there as you have already experienced with me Scott. But point well taken and I am eager to dissect Gozreh's work to see how he did this.

Gozreh is it a simple settings change that I need to do to make all the dropdown menus to goto blank selections (or Reset) when a new Client Name is selected?

Thanks again so much for all your help!
GozrehSoftware Developer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
You can set the other combos to blank values in the AfterUpdate event of the first combo:

Me.ComboName = ""
Dana DIT Consultant
CERTIFIED EXPERT

Author

Commented:
Gozreh, thank you for explaining! It works great but it still isnt clearing the other 2 dropdown boxes after a first selection. I also tried what Scott has recommended and i think it does something but it is also not clear the 2nd and 3rd dropdown boxes after an initial client name selection is made.

Any idea why this is?

Thanks Again!
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Dana DIT Consultant
CERTIFIED EXPERT

Author

Commented:
Understood Scott, I will work on this tomorrow as my day is packed with fun stuff today! (Major Work!) Thanks for explaining and the quick response! Have a great day!
GozrehSoftware Developer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.