P Pastor Andrew Alexander Feb 7, 2005 #1 Is there a way to place a button on a form to clear the record after you have saved the record to DB?
Is there a way to place a button on a form to clear the record after you have saved the record to DB?
D Debra Dalgleish Feb 7, 2005 #2 You could record a macro as you select the data entry cells, and clear them. Add a button to the worksheet, from the Forms toolbar. Assign your macro to that button. For instructions on storing and using macros, you can read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm
You could record a macro as you select the data entry cells, and clear them. Add a button to the worksheet, from the Forms toolbar. Assign your macro to that button. For instructions on storing and using macros, you can read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm
