Welcome to the forums!
As a starting point (and assuming you have an unbound form), I would suggest looking into running an Append query
. If you need help figuring out how to build and run a query from a command button, I would recommend looking at Martin Green's site, he has a six part lecture on VBA and SQL
. After you build and run the query in the code, then you'd just need to clear the form; and if you need help on this, you might want to post what kind of controls you have, how you enter in the data, and basically define what "automatically clear the form" means.