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.
 
Top