Access Question: How do I add a button that adds a new record when clicked?

[GoingUp]

I'm making a nice GUI frontend for a database Im working on. I want to have a button that clears all of the drop boxes and text boxes and inserts a new record without wiping out the one that I was just viewing. Anyone know of a good way to do this? Im using Office XP.

Thanks

 

[KB]

I don't thin kthere are any built-in functions to do that. You are probebly going to have to use DAO or ADO and execute a SQL INsert statement in code.

 

[GoingUp]

Originally posted by: KB
I don't thin kthere are any built-in functions to do that. You are probebly going to have to use DAO or ADO and execute a SQL INsert statement in code.

Just found that command using the button wizard. Does everything automatically for you