Les,

If you know VBA you can try writing a reinitialization statement in the
module and call it after the append to ACCESS, else, write a macro to clear
the fields and call the macro after the command button to append the data to
ACCESS. The best approach depends on your comfort with VBA and/or macros.

Rick



"Les" wrote in message
...
I have an excel spreadsheet set up like a form. This form has 6 pieces of
data the user puts in. Once they are filled in the user needs to click on
a
command button and have those 6 pieces of data dumped (appended) into an
Access database. After that is done I want to clear the 6 fields where
the
data was in Excel.

Can someone help me?

Thanks,

Les