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
|