Need to Create "Duplicate Record" option

[Jody]

Thanks, Larry, for the suggestion. However, I'm fairly
new at this. Could you offer suggestion on what the VBA
code should be?

************************************************

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

message

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!

..