B
BLV 06
I am assigning a mapping assignment to a program on a form. The program
field and information is on the main form. I am having trouble creating the
subform for the mapping assignment. I have set up the form so that the Area,
type and class that the user selects is stored in a "mapping assignment"
table. And that is working fine.
Now, I want to add some sort of validation/filtering functionality to the
options that are selected on the mapping assignment subform.
I have 3 fields on the mapping assignment subform, "Area", "Type", and
"Class". These three fields have a tiering structure as follows:
Area A - Type A1, Type A2, Type A3
Area B - Type B1
Area C - Type C1, Type C2
Type A1 - Class a, Class b, Class c, Class d
Type A2 - Class d, class e, class f, class g
Type A3 - Class a, Class b, Class c, Class d
Type B1 - class d, class e, class f, class g
Type c1 - class h, class i, class j, class k
Type c2 - Class h, class I, class j, Class k
Each of the fields on the form is a listbox. I have places controls on each
of the 3 fields an linked it back to a table that contains all the choices
for areas, types, and classes (3 separate tables). I want the form to
function as follows: when Area A is selected, only type A1, A2, A3 show up as
options, etc. My problem is now that all type choices appear in the listbox,
no matter what was selected for the Area. And then when an area is selected,
I only want the associated classes to show up as options in the listbox.
Can someone get me started on the coding of this?
field and information is on the main form. I am having trouble creating the
subform for the mapping assignment. I have set up the form so that the Area,
type and class that the user selects is stored in a "mapping assignment"
table. And that is working fine.
Now, I want to add some sort of validation/filtering functionality to the
options that are selected on the mapping assignment subform.
I have 3 fields on the mapping assignment subform, "Area", "Type", and
"Class". These three fields have a tiering structure as follows:
Area A - Type A1, Type A2, Type A3
Area B - Type B1
Area C - Type C1, Type C2
Type A1 - Class a, Class b, Class c, Class d
Type A2 - Class d, class e, class f, class g
Type A3 - Class a, Class b, Class c, Class d
Type B1 - class d, class e, class f, class g
Type c1 - class h, class i, class j, class k
Type c2 - Class h, class I, class j, Class k
Each of the fields on the form is a listbox. I have places controls on each
of the 3 fields an linked it back to a table that contains all the choices
for areas, types, and classes (3 separate tables). I want the form to
function as follows: when Area A is selected, only type A1, A2, A3 show up as
options, etc. My problem is now that all type choices appear in the listbox,
no matter what was selected for the Area. And then when an area is selected,
I only want the associated classes to show up as options in the listbox.
Can someone get me started on the coding of this?