Fill in checkbox discriptions based on combobox selection

[SparkByte]

I have just inherited an Access application that no less than 3 other people have made major changes to and I am trying to clean it up and move the data over to a MS SQL backend.

So far I have modified the column names to conform to standards (no column names like [Delete]) (Not joking).

Modified all the forms, reports and queries to reflect the new column names.

Converted all the queries that would not migrate via the upsizing wizard.

I also have built a SSIS package to import, verify and remove duplicate records.

Now for the real question.
There are 2 forms I would like to change (One add Case, and one Update Case). What I would like to be able to do is have a combo box select what processing track is being used and based on that selection 4 to 7 check box descriptions get filled in.

So say John Smith calls in and requests XYZ documents, these documents are of XXX type so they would be a Track 2 request, which means that there are 7 checkboxes that could be selected depending on the type of information they need out of the requested documents. When the Call Rep. selects 'Track 2' in this case, the descriptions for the checkboxes get filled in from on a lookup table based on the 'track 2' selection in the combo box like the descriptions for menu options get filled in on the Switchboard Menus.

Any help on how to accomplish this would be greatly appreciated.

 

[Galaxiom]

I am having trouble grasping the question. What are the checkboxes for?

If the relationship between Track and the checkboxes is fixed then you should only be storing the Track information because the checkboxes can be determined from the Track.

Are the values for the checkboxs just the defaults and will need to be stored?

 

[SparkByte]

Sorry bad Discription after rereading.

So say John Smith calls in and requests XYZ documents, these documents are of XXX type so they would be a Track 2 request, which means that there are 7 checkboxes that could be selected depending on the type of information they need out of the requested documents. When the Call Rep. selects 'Track 2' in this case, the descriptions for the checkboxes need to get filled in from on a lookup table based on the 'track 2' selection in the combo box like the descriptions for menu options get filled in on the Switchboard Menus.

I cannot figure out how to auto display checkboxes based on track selection.