I'm trying to combine a macro with two actions, but one of the actions I want to make the macro do is insert a record (when I put it on a form). Is there any way to make a macro that inserts record (after a user enters information into the form)?

Why not just use a bound form and let Access take care of the insert?

It is a bound form, but I want instead of letting the form update itself, I want to combine that action with a macro that exports the table that is updated to excel. I created the macro, but I need to know how to combine the two actions.

Thanks,

Nick