Activate different form controls

[BrianDG01]

I would like to activate different controls on a form based on a required entry (lookup table). Basically I have a master list table of all records. These records then require additional information based on what feature the record represents. The additional data are in different tables as they are quite different types of data.

Previously I have had sub-forms for the different streams but it is not transparent and users can get a bit confused. I figure if I can have the master list entry controls at the top of the form then two different data entry areas below that represent the different streams then it would be more clear to the user. The different streams would be activated or deactivated based on data in the master list control (as a switch).

Does this make sense and can anyone assists.

Thanks,

 

[arnelgp]

what do you mean by "activate", enable or visible?

 

[BrianDG01]

Activate. So the information stream that is not relevant for the particular data type is disabled.

 

[arnelgp]

sorry but what is a master list control, is it a listbox, a datagrid. if it is a listbox you can add column to it which signals which controls should be disabled/enabled.

sorry lost there a bit.

 

[BrianDG01]

I have what I refer to as a master table. It is a list of samples with fields for common metadata only (date, location, form, source and [type]). There are two possible entries for [type], QC or BH. There are different tables for samples that are QC and ones that are BH because they have different metadata requirements.

It would be nice if I could have a form that held the master table controls as well the controls for the two child tables. But the controls for the child tables would be activated or deactivated deepening on the value of [type] in the master table controls.