Filtering ComboBox Issue

MNM

Registered User.
Local time
Today, 19:14
Joined
Mar 3, 2014
Messages
61
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
 
Greetings,
pere_de_chipstick at www.utteraccess.com suggested the appropriate solution.
He submitted it in SQL format, but took the intent for the design view I'm used to working in.
Here it is:
WHERE ((([CourseType])=[Forms]![FRM_Selector]![CourseType])) OR ((([Forms]![FRM_Selector]![CourseType])=5));
This gives me the appropriate texts for the specific courses w/ the intent of all available texts for the Private Course.
I took it a step further and also added a level filter to narrow the choices even more, except for the Private Course.
Thanks to all for being here,
MNM
 

Users who are viewing this thread

Back
Top Bottom