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:
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.