Command buttons with macros

  • Thread starter Francis Cunningham, Jr.
  • Start date
F

Francis Cunningham, Jr.

Hi,
Can I create a macro with a command button to duplicate a record but remove
one or more fields in the process. can not duplicate a record because it
would create of a primary field dulpication. I want to be able to click the
button, remove the primary key field than duplicate the record with the
primary field emply, I'll re-enter the field with a new number before saving.
Currently using Access2000.
Frank
 
E

Eric Blitzer

create an append query that references the fields on the form and run it with
a macro.
 
S

Steve Schapel

Francis,

Agree with Eric about using an Append Query. And just to add to his
suggestion, if you wish, you will be able to incorporate your new
primary key field value into the query.
 

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

Top