Search Filter

[PJ]

I have multiple unbound text/combo fields in a form. Once you input your
criteria I have a command button that when you click on it based on your
criteria it will return a list of customers in your text field. I have
command button to scroll through the list and a check box next to it to
select a various customer you would like to print out on a report. My
problem seems to be when multiple users are in this form it is not clearing
out the previous user’s selections. Ideas on how to resolve this issue?

 

[Lord Kelvan]

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