Sort Field or Not Sort Field

P

protean_being

I have a form that contains a check box called chkPrimaryLocation and a combo
box called cboPrimaryLocation. This form is an entry page that runs a query
to generate a report. What I want to do is to uncheck the box if I want to
see all non null fields and check the box if I want to see only the selected
location in the combo box.
How do I define the criteria for PrimaryLocation in the query to make this
work?
 
K

KARL DEWEY

Criteria for PrimaryLocation --
Like IFF([Forms]![YourFormName]![chkPrimaryLocation] = 0, "*",
[Forms]![YourFormName]![cboPrimaryLocation])

In neither case will you records that location is null.
 
J

John W. Vinson

Criteria for PrimaryLocation --
Like IFF([Forms]![YourFormName]![chkPrimaryLocation] = 0, "*",
[Forms]![YourFormName]![cboPrimaryLocation])

In neither case will you records that location is null.
Click to expand...

minor typo, Karl - I'm sure you meant IIf (not IFF).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Sharepoint not capturing staff name when automation runs 0
Combo or list box 0
Delete all data after a symbol in a field 0
Program buttons to create a word document 0
Open a form from a combobox on the switchboard based on a field inthe subform 1

Top