Using Switchboard to determin field value

[pbrown2]

Currently there are approximately 11 options on a switchboard. Once the user clicks which one they want it opens the respective form. The form then has a default value based on the table.
I.E.

[] Cars

[] Trucks

[] SUV

If the user clicks the button next to Trucks a form will open with the field named "Plant" defaulted (via the underlying table) to "Trucks".

The potential problem is that there is a need for 4 forms per plant and as anyone can imagine this could only get larger.
The forms are:
(1) Main Entry & (1) Main Entry Subform
(1) Mgmt Review & (1) Mgmt Review Subform

Therefore, I would like to have 1 form that would accomodate all existing and future plants. By having the field "Plant" to be filled in via the choice the user makes. Hence if the user chooses Car, the form would have Car in the plant or if they choose Truck, Truck would appear.

By doing this, it would also eliminate the need to run several admend queries/macros to combined all the plants into one set of tables for a "Master List".

Starting form:
Switchboard


Entry form:
Entry
Field Name:
Plant



Any suggestions?

Thank you for any and all help,

PBrown