Filter report off of Form (User Entry)

[Guest]

Hello,

I created a form, which allows users to enter a search/filter criteria then
produce a report.

If the user does not use one of the available search fields, then I would
like that field to bring back 'ALL' or "*".

I added the following filter to my query, but it does not seem to work.

IIf(IsNull(([Forms]![frm_CallLogOptions]![Branch
ID])),"*",([Forms]![frm_CallLogOptions]![Branch ID)]))

Essnetially - check to see if the txt box is empty, if it is bring back all,
else use the entry.

Any help would be much appreciated.

Thanks
ACase

 

[Rick B]

to filter for all if blank, you would do something like the following...

Like [EnterSomeData] &"*"

This will string the entry together with an asterisk. if nothing is
entered, then it simply uses an asterisk (which gets all data).

That is how it is done in the query design grid. I'm sure you can modify it
to meet your needs.

Rick B