Solved

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

Posted on 2010-11-08
3
192 Views
Last Modified: 2012-05-10
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
Comment
Question by:ARampton
  • 2
3 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 34085641
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
 

Author Comment

by:ARampton
ID: 34085812
Fantastic, almost got there but had Like in front of my * instead of in front of my Iif...

Great quick response
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 34085927
no worries :)
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now