asked on

Filter form

Experts,
I have a filter form for a report.
The filter form has 4 unbound fields.
What is the trick to making the report open if some of the unbound fields are Null?
Are you suppose to add <>False or True under IsNull([forms]![frmLCIssuedQryType]![cboCurrency])
I continually play around with the control source of the report by adding or taking away criteria based on whether or not an unbound filed is null or not null and I just get no where with it for filter forms that have many unbound fields. I am missing something and I am spending too much time on this. I need help. Give me the expert insider trick to doing this that can be applied to each filter form?
Please see attachment
Thanks

pdvsa

ASKER

For example, in the above screen print, if the filter form had a null for txtLCType then I want it to show all LCTypes but based on whether or not the other unbound fields were null or not null. Hope you follow...ask if not...

pdvsa

ASKER

I am thinking that for each unbound field on the filter, you need two columns in the qry design: one that is the actual field dragged down and the other that has an IIF statement that handles the null on the filter form (if the unbound field was null). There must be a process for this to handle each unbound field. I am lost...need help.

pdvsa

ASKER

I woudl post an SQL but I dont think that wil help too much. The process is what I am looking for.

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pdvsa

ASKER

Lsm: i think you mentioned this before. I have always had the criteria inside the report and not within the form. I know what you mean but i dont really know how to do it. Can you provide a general exaple that maybe i can adjust to fit my needs?

Thank you

SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pdvsa

ASKER

thanks for the advice and that bit of information about why it is recommend to have the criteria in OpenReport. I think I understand this. YOu have the Docmd.open report " " then have the where stuff after in some section after a comma. Intellisense will tell me this.

thanks