Criteria

[ptrifile]

I currently use the following to show all records if a value is not selected.

Like '*' & [forms]![frmprocedureexceptiontracking]![losscode] & '*'

The problem i am now faced with is if someone chooses a code from the drop down and it is not in the data all data is shown. I would like it to show nothing if something is chosen and its not in the data set. I originally used this so that if nothing was picked it would return all the results. Now i just need to modify it a bit.

Hope that made sense. Thanks for any help here!

Paul

 

[ptrifile]

Please disregard. I simply removed the & and '*' from the end and it works as desired.

 

[PHV]

What about this ?

=forms]![frmprocedureexceptiontracking]![losscode] OR forms]![frmprocedureexceptiontracking]![losscode] Is Null

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886