SubForm Problem

[GregSmith]

I have about 15 different tables that represent my servers.

I have a dropdown on my form that selects the server that I need information on. How can I get the dropdown to select the correct table and display it?

When I create the subform, I can hardcode the record source to be either of the 15 servers but cannot get it to change the record source if the dropdown changes to a different server...

 

[madhouse]

Is the subform within the form with the drop down?

 

[GregSmith]

Yes - The subform is located at the bottom of the form.

 

[Rich]

Why 15 tables?

 

[madhouse]

Good question, why 15 tables??

But the problem as to why the subform isn't changing when a different server is selected from the drop-down maybe that your not requerying the subform (depending on what method you are currently using to populate the subform after an option has been selected in the dropdown box).

 

[GregSmith]

Each Table pertains the the server information.
Should I just do 1 HUGE table that contains all my servers?

 

[madhouse]

One table would easier to deal with. All you need is a table with a field called something like fldServerName that identifies each server and then add the rest of the fields as necessary.

 

[madhouse]

Should have added that by just having a single table this will not resolve the issue your having with the subform. At the moment, when you click an option from the list how do you populate the subform with details of the selected server?