I have a Value list that filters a subform based on Question Type ("BackgroundQ";"Main SystemQ";"Web LayerQ" ...etc). The subforms criteria for QuestionType is [cboFilter].[value]. How would I add an "ALL" to the value list to show all the Question Types in the subform?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Add a "ALL" selection to an Unbound Value List Filter?
- Thread starter cruzan1
- Start date
Say the values list is:
"BackgroundQ";"Main SystemQ";"Web LayerQ" ...etc;"(All)"
The criteria is now:
[cboFilter].[value] Or [cboFilter].[value] = '(All)'
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
"BackgroundQ";"Main SystemQ";"Web LayerQ" ...etc;"(All)"
The criteria is now:
[cboFilter].[value] Or [cboFilter].[value] = '(All)'
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question