A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Search Filter



 
 
Thread Tools Display Modes
  #1  
Old May 27th, 2010, 11:49 PM posted to microsoft.public.access.forms
PJ
external usenet poster
 
Posts: 265
Default Search Filter

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?
Ads
  #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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 OfficeFrustration.
The comments are property of their posters.