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
|
|||
|
|||
Clearing a field
I have a command button to clear a search a (Check box) but sometimes users
forget to clear the search. When other users use that form the check boxes are not cleared. How do I code the form so when they exit the check box clears. Thank You In Advance!! |
#2
|
|||
|
|||
Clearing a field
Other users?
There should be no other users. NEVER share the forms in an Access database. You need to split the database into a back-end that contains all the tables and a front-end that contains everything else. Link the tables in the back-end to the front-end, and put a copy of the front-end on each user's workstation. Failure to work that way in a multi-user environment will eventually result in a corrupted database. Text can be cleared using the Enter event on the textbox: Private Sub txtSearch_Enter() Me.txtSearch = "" End Sub -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access Co-author: "Access 2010 Solutions", published by Wiley "PJ" wrote in message news I have a command button to clear a search a (Check box) but sometimes users forget to clear the search. When other users use that form the check boxes are not cleared. How do I code the form so when they exit the check box clears. Thank You In Advance!! |
Thread Tools | |
Display Modes | |
|
|