Link to home
Start Free TrialLog in
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
ASKER CERTIFIED SOLUTION
Avatar of Gozreh
Gozreh
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of Dana D
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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can set the other combos to blank values in the AfterUpdate event of the first combo:

Me.ComboName = ""
Avatar of 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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial