Is there a Macro that I can write that would clear unbound text boxes on my form when I click a button?
Is there a Macro that I can write that would clear unbound text boxes on my form when I click a button?
Let me rephrase what I am trying to do. I have a sign in form for my confereances and after I hit the save button, it clears most of the fields. Basicly everthing that is bound to that record.
However, the text boxes that I use to pull up my employees information, do not clear. How do I clear these when the button is pressed?
I would use some vba. When you hit the Save button, you are (I believe) exectuting the button's On Click event. So, in the On Click event add some code along these lines at t he end of the existing code
yourTxtField1 = ""
yourTxtField2 = ""
...
yourTxtFieldx = ""
When the button is clicked, your save would occur and the yourTxtFields would be set to zero length strings