Need to create "duplicate record" button

[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!

 

[Larry Linson]

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

 

[Jody]

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!