copy record macro

  • Thread starter Thread starter jim branum
  • Start date Start date
J

jim branum

how do i build a macro button to copy the info to a new
record from current form displayed
 
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
 
You must log in or register to reply here.

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
Embedded Macros 2
Retrieving specific record from subform using a macros 1
Returning to Record after running Macro 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top