Help with creating CLEAR button
The easiest way to do this would be to just record a macro. You can do this by choosing Tools:Macro:Record New Macro. Name your macro, click OK, and then manually perform the activities you want to accomplish. Once complete, go back to Tools:Macro:Stop Recording. Now you have your macro.
You can either run the macro by going through Tools menu again, or if you want a button, goto View:Toolbars:Forms. This will show the Forms toolbar which you can choose Command Button off from. Create your Command Button, right click on it and choose Assign Macro. Once you assign the macro you recorded earlier, clicking the button will initiate it.
|