M
mscertified
I have a subform that lists audit questions, defects and corrective actions.
The defects and corrective actions come from separate tables, however, the
user wants to be able to type in their own text on occasion (not very often),
so I have 'Limit To List = No' on both combo boxes.
Because of this, the Questions table stores the full text chosen or entered
rather than an id linking back to the Defect or Corrective Action table (this
breaks my heart)
If a user selects a Defect from the drop-down, the Corrective Actions are
dependent on the Defect. My problem is when the user types in a value for
Defect, how does the Corrective Action combo box behave? Obviously the
drop-down is meaningless. How do I disable the drop down and force the user
to enter their own text for the corrective action when they type in their own
defect? Any ideas how to do this are welcome.
The defects and corrective actions come from separate tables, however, the
user wants to be able to type in their own text on occasion (not very often),
so I have 'Limit To List = No' on both combo boxes.
Because of this, the Questions table stores the full text chosen or entered
rather than an id linking back to the Defect or Corrective Action table (this
breaks my heart)
If a user selects a Defect from the drop-down, the Corrective Actions are
dependent on the Defect. My problem is when the user types in a value for
Defect, how does the Corrective Action combo box behave? Obviously the
drop-down is meaningless. How do I disable the drop down and force the user
to enter their own text for the corrective action when they type in their own
defect? Any ideas how to do this are welcome.