Greetings,
I have a form on which are two combo boxes. In the first, the user selects a course type. In the second, the user selects the text for that type of course.
I've gotten the second control to filter the appropriate texts.
The problem lies with the "Private Course". For this case, I would like to have the user select from the entire list of texts, e.g. Business; General; Special.
I would think an IIF statement is used in the criteria for the CourseType_ID in the row source query.
What I have so far is:
IIF([Forms]![FRM_Selector]![CourseType]<>5, [Forms]![FRM_Selector]![CourseType])
However, I have yet to figure out how to get all texts to display when CourseType=5(Private Course).
Any assistance would be greatly appreciated.
Mark
I have a form on which are two combo boxes. In the first, the user selects a course type. In the second, the user selects the text for that type of course.
I've gotten the second control to filter the appropriate texts.
The problem lies with the "Private Course". For this case, I would like to have the user select from the entire list of texts, e.g. Business; General; Special.
I would think an IIF statement is used in the criteria for the CourseType_ID in the row source query.
What I have so far is:
IIF([Forms]![FRM_Selector]![CourseType]<>5, [Forms]![FRM_Selector]![CourseType])
However, I have yet to figure out how to get all texts to display when CourseType=5(Private Course).
Any assistance would be greatly appreciated.
Mark