• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

Showing all records on a Query whose criteria is from a form ComboBox List item "All"

I have a status ComboBox list [ViewStatus] on my form [MainForm] header which I use to restrict the records showing on this form's detail section

The Form is based on a query with Status criteria  = [Forms]![MainForm]![ViewStatus]

This works well with exact matches but I also want [ViewStatus] to allow showing  "All" records

|What is the easiest way of writing this criteria to show all records when requested?

Criteria Like "*" usually works but I can't find a way of translating All to anything that works
0
ARampton
Asked:
ARampton
  • 2
1 Solution
 
rockiroadsCommented:
Using * should work. Looks like you need the IIF check to determine the selection

eg

Criteria LIKE IIF( [Forms]![MainForm]![ViewStatus] = "All", "*",  [Forms]![MainForm]![ViewStatus])
0
 
ARamptonAuthor Commented:
Fantastic, almost got there but had Like in front of my * instead of in front of my Iif...

Great quick response
0
 
rockiroadsCommented:
no worries :)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now