copy record macro

J

jim branum

how do i build a macro button to copy the info to a new
record from current form displayed
 
S

Steve Schapel

Jim,

In a nutshell:
Make a query which selects the record as displayed on the current
form. Make it into an Append Query. Make a macro using the OpenQuery
action to run the append. Assign this macro to the Click event of
your button.

- Steve Schapel, Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
pasting problem 0
Macro to copy value in field and insert it into filter 2
Pasting cell contents into a macro 1
Retrieving specific record from subform using a macros 1
Returning to Record after running Macro 2
Embedded Macros 2
ms access 2003 to 2007 MACROS 6

Top