OpenForm Error!!!!!

[SilFaz]

Hi everyone,

I have created a form that searches my main table based on criteria entered by the user and returns matching records in a subform. The search works great, but I also have a Clear All button that sets all the search fields to Null when pressed.

The problem is that after I press the Clear All button and try to search again, I get an error message that says "The OpenForm action was canceled". How can I fix this???

I also have reports being created from that same form, using the same query and it has no problems at all.

Please help!!!

Thanks,

Silvia

 

[SilFaz]

Oh, and if I press Esc after I get the error or after I click Clear All, the search works again...

Silvia

 

[GTLoco99]

The only thing I can think of that would cause this is if you are truely setting the values of the fields to Null, or an empty string(I.E. "&quot.

Thanks
Glen