remove filter by form "pre determined" values?

mafhobb

Registered User.
Local time
Today, 02:05
Joined
Feb 28, 2006
Messages
1,249
I have two fields in a form that everytime that someone tries to do a "filter by form" have a "default" value pre entered. I do not know where this pre-defined value comes from and it needs to get deleted every time.

How do I make sure that when anyone uses the "filter by form", the form shows up with all fields empty?

Thanks

mafhobb
 
Something else that would work would be to clear all saved filters when the form is opened (OnOpen)

What would be the appropiate code to do so?

Mafhobb
 
Hi!

What about "Me.AllowFilters=False" put in OnLoad of form?

Krava
 
Done! I figured it out..

Thanks for your help guys..

mafhobb
 

Users who are viewing this thread

Back
Top Bottom