DROP DOWN for ALL CATEGORIES on form [Solved]

DROP DOWN for ALL CATEGORIES on form

As of right now I have a drop down on a form and in the criteria row of the query that the Report is based off of - I have the sytax for what is selected on the FORM FOR  that category in the dropdown box.
 
I need the option for All or really would like to call it CONSOLIDATED ON THE DROPDOWN -  when i use All - in the combo box - I get 0 records.  How can I use the dropdown box on the form to say CONSOLIDATED -  OR ALL (IF i HAVE TO) and how can it include
All categories for the query that the report is based on.
 
Gone brain dead??/
 
thanks,
bkel

Keys to the Problem DROP DOWN for ALL CATEGORIES on form

Download Error Fixer for Free Now

It's hard to see the wood for the trees with all the extra parentheses which Access throws in when you build a query in design view.  Try simplifying the WHERE clause to:

WHERE ExpenseCrossTabPlanExpenseAlloc.Mega = [Forms]![FormQueryExpenseDetailALLOCATIONS]![cboMega]

OR ([Forms]![FormQueryExpenseDetailALLOCATIONS]![cboMega] = "Consolidated"
AND [Mega] IN("Small", "Healthcare", "Medium/Large","Federal","K-12","Higher Ed","State & Local"));

However, this may have nothing to do with the error of course.

To check for Windows updates

  1. Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.
  2. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.
  3. If any updates are found, click Install updates. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

Another Safe way to Fix the Problem: DROP DOWN for ALL CATEGORIES on form:

How to Fix DROP DOWN for ALL CATEGORIES on form with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Open it, and it will perform a scan for your computer. The junk files will be shown in the list.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.


Related: Cant Download Or Open Programs..,Chm Compiles But Won't Run,Cd/dvd Driver Is Corrupt Or Missing-- Windows Cannot Load The Device Driver For This Hardware. The Driver May Be Corrupted Or Missing. (Code 39),Cant Get Messanger To Boot Up,Change The Letters Into Asterisk While Typing In The Cell!!,Computer Does Not Shut Down Instead It Restarts...,Conditional Formatting - Highlight Several Sets Of Duplicates,Computer Freezing After Updates,Conditional Format Search Part Of Text,Computer Repeated Freeze Requiring Hard Reset, And Many Other Queries,Deleting Messages From Deleted Items Folder,Delay Before Next File Starts After A File Has Finished Copying To Or From USB.,Default Search Provider Error,Dell Running Windows 7 Is Running Very Slowly,Dell Inspiron 1525 Webcam Issue.,How To Use Digital Signage To Reach College Students,One Simple Strategy To Organize Your Online Business,The Next Generation: Xbox 360,Best Home Storage Organization Tips,Learn To Sing Fast
Read More: How Can You Fix - Disk defragmenter is freezing at 33% analysed - left for 6hours and still frozen?,Troubleshoot:Domain Log on for Windows 7 Error,Troubleshoot:Diskpart problem: current read only and read only flags,How to Fix Error - Downloads Randomly Stop for No reason?,Solution to Error: Does windows 7 GUI and applications will be color managed ?,Dell XPS laptop running Windows 7, monitor switches off after 2 mins idle time, but should be set to 15 minutes,deleted emails from windows live eamil account can i get those back deleted on Oct. 24 2009,Do anyone know about the EULA for AutoRoute 2007?,Driver does not read video dvd,Display bug in Excel 2007 and 2010. What to do?
[PR]
by facebookscript | 2016-09-30 10:19