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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 | |
|
|