I'm trying to limit the values in a combo box (Combo33) based on the previously-selected value of a different combo box (Combo42) in the same form (FRM_TRAINING_PROTOCOL). In the row source for Combo33, I have:
Expand|Select|Wrap|Line Numbers
- SELECT TBL_PROTOCOL.[PROTOCOL NUMBER]
- FROM TBL_PROTOCOL
- WHERE (
- ((TBL_PROTOCOL.[STUDY NAME])
- =[Forms]![FRM_TRAINING_PROTOCOL]![Combo42])
- )
- ORDER BY TBL_PROTOCOL.[PROTOCOL NUMBER];
Back in form view, though, Combo33 is not updating based on the value of Combo42. What do I have wrong in the above code? FYI, I do have Combo33 set to requery after update of Combo42.
Thanks for your help!