Avatar of pdvsa
pdvsa
Flag for United States of America asked on

Report and a Form Filter

Experts, I have a report that uses a filter form:  "frmFilter_ShortByMonth"
I have a unbound combo:  "frmFilter_ShortByMonth.cboExecutiveOwner with a query as a row source:  
SELECT Import_Excel.ExecutiveOwner FROM Import_Excel GROUP BY Import_Excel.ExecutiveOwner;
The user selects a name from the cboExecutiveOwner then clicks the button and the report shows data for that selection.  

I now need to add functionality to show only records where the [ExecutiveOwner] is not null or "".
The user has to be able to do this has to be on the fly.  I know I can put the criteria within the query but I need it to be more dynamic.  

SELECT Import_Excel.*
FROM Import_Excel
WHERE (((Import_Excel.[Due Date per docs])>=[forms]![frmFilter_ShortByMonth]![txtDateFrom] And (Import_Excel.[Due Date per docs])<[forms]![frmFilter_ShortByMonth]![txtDateTo]+1) AND ((Import_Excel.Completed) Is Null) AND ((Import_Excel.ExecutiveOwner) Is Not Null And (Import_Excel.ExecutiveOwner)<>""));
Microsoft Access

Avatar of undefined
Last Comment
Gustav Brock

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Gustav Brock

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
pdvsa

ASKER
oh yes, the check mark.   I forgot about that option.   Thank you once again...
Gustav Brock

You are welcome!

/gustav
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23