Form disappears

[sdawson]

I have a form with a few filter buttons which normally works fine.
The problem is that when the filter condition finds no matches, the form just displays the background and nothing else!
I would have expected the field to display no values.
The code on the filter buttons is something like this.

Me.Filter = "[Credit Approv] = '" & "New" & "'"
Me.FilterOn = True
Me.AllowEdits = True
Me.AllowAdditions = True

Any ideas?

Thanks

 

[Brian1960]

Try Error trapping

The probability is that this is caused by null values in the calculation so trap these or
On Error Resume Next

and ignore the problem