Thread: Search Filter
View Single Post
  #2  
Old May 28th, 2010, 02:12 AM posted to microsoft.public.access.forms
Lord Kelvan
external usenet poster
 
Posts: 637
Default Search Filter

I have never had this problem before but based on what you have said
here is my logical answer if i am wrong tell me and I’ll thing up
something else.

I would recommend in the onopen or onload event probably on the onload
event as it runs after onopen (and if I got that wrong apologies) set
each of the values in the filter fields to “”

Ie

Private sub Form_Load()
Myfiltercontrol1.value = “”
Myfiltercontrol2.value = “”
‘etc
End sub

the point is never trust a program to set anything.

I suppose the other alternative is to create an mde file but again I
have never had this problem with multiple users accessing a form

Regards
Kelvan