Avatar of Dana D
Dana D
 asked on

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

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
Microsoft AccessMicrosoft DevelopmentMicrosoft Applications

Avatar of undefined
Last Comment
Gozreh

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Gozreh

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Scott McDaniel (EE MVE )

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 D

ASKER
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!
SOLUTION
Gozreh

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Scott McDaniel (EE MVE )

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

Me.ComboName = ""
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Dana D

ASKER
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!
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Dana D

ASKER
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!
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.