Need to create "duplicate record" button

  • Thread starter Thread starter Jody
  • Start date Start date
J

Jody

I have created a travel itinerary database for our sales
reps to use. A simple data entry screen contains the
following information: SalesRep, Date, CustName,
CustCity, CustState, Activity, Purpose, and Comments with
a subform imbedded containing fields to collect individual
contact info: ContactName, ContactTitle, ContactPhone.

Many times our reps would like to "copy" a record to cover
a time period anywhere from 2-5 days or more. They do not
like to keep typing the same information each day.

Is there a way to create a "duplicate record" button and
at the same time have the date automatically be
incremented by one day?

Would appreciate any help you can give.

Thank you!
 
You can do it rather easily with VBA code. There's no "copy this record with
an incremented date" option in the Command Button Wizard, though.

Larry Linson
Microsof Access MVP
 
That's just it (I'm fairly new at this) -- I don't know
what the VBA code should be. Can you offer suggestion?

Thanks!
 
Back
Top