Insert Record Macro Question (1 Viewer)

npierson

Registered User.
Local time
Today, 17:18
Joined
May 14, 2001
Messages
42
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)?
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 12:18
Joined
Feb 19, 2002
Messages
43,296
Why not just use a bound form and let Access take care of the insert?
 

npierson

Registered User.
Local time
Today, 17:18
Joined
May 14, 2001
Messages
42
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
 

Users who are viewing this thread

Top Bottom