Macro to add and clear fields

[Skroof]

Macro to add and clear fields - I added a new "add record" button and this time i am controlling it using the macro, it saves data to its table but does not clear thereafter, so i have to manualy remove what was typed in. How can i add another macro to add record to table and the clear it off the list boxes or fileds ?

[Bob Fitz]

I don't use macros, but if the form is bound to a table/query, then I don't think you need code or a macro to save the entered data. Just moving to another record (existing or new) will cause access to save the data. So, you could create a macro that uses the GoToRecord action and select "new" from the list of available records. Or better still you could do it with one line of code:
DoCmd.GoToRecord , , acNewRec