A
a.t.brooks
Hello
I have a subform witin a subform.
In that subform are two comboboxes.
I would like to know how to get the list in combobox 2 to be dependent
on combobox 1.
Specifically, box 1 is measurement_unit_type with values: "Time",
"Distance", "Mass" etc..
Once this is selected. I would then like the contents of box 2 to be
filtered so that if, for example "Time" is selected, the values would
be "seconds", "hours", "days", if Mass is seleted, then the values
would be "grams", "kilograms", etc..
I have made a table as such;
Time | seconds
Time | hours
Time | days
Mass | miligrams
Mass | grams
Mass | kilograms
....
The problem, I think is that the combo boxes are in a subform on a
subform.
Does anyone know how I could get this to work?
I've tied building a query with the following as criteria, but it
doesn't work
Forms![frm_mainform].[frm_subform1].[frm_subform2].Form!
[cmb1measurement_unit_type]
Any help would be appreciated
I have a subform witin a subform.
In that subform are two comboboxes.
I would like to know how to get the list in combobox 2 to be dependent
on combobox 1.
Specifically, box 1 is measurement_unit_type with values: "Time",
"Distance", "Mass" etc..
Once this is selected. I would then like the contents of box 2 to be
filtered so that if, for example "Time" is selected, the values would
be "seconds", "hours", "days", if Mass is seleted, then the values
would be "grams", "kilograms", etc..
I have made a table as such;
Time | seconds
Time | hours
Time | days
Mass | miligrams
Mass | grams
Mass | kilograms
....
The problem, I think is that the combo boxes are in a subform on a
subform.
Does anyone know how I could get this to work?
I've tied building a query with the following as criteria, but it
doesn't work
Forms![frm_mainform].[frm_subform1].[frm_subform2].Form!
[cmb1measurement_unit_type]
Any help would be appreciated