I'm relatively new to access and have a problem. I have multiple rows of information on a form, and each of these rows has a few text boxes and one combo box. The combo box needs to have different information in it based on another field in the row. The combo box is Units, and if the Measurement Type is "Length" for example, then the combo box would populate itself with "inches", "cm", "mm". There are about 8 different Measurement Types and each has a different list of units. My question is whether or not this is possible given the current form design. Attached are two pictures. The first one is the form in Design view, the second is in form view.
For Example,
In the combo box marked A, I want the drop down to contain "cm", "inches", "mm".
In the combo box marked B, I want the drop down to contain"lbs", "kg", "g".
In the combo box marked C, I want the drop down to contain "inch-lbf", "ft-lbf", "oz-in", "oz-ft".
And each one as we go down the line from there could have a different set of values.
Is it possible to have all of these at the same time?