How To Automate Record Duplication

[Kevin]

You can create an append query to take information from
the forms current record and append it to a new record,
then for the date just add 1 to the date in the record.
Doing that may be difficult for you depending on how much
programming experience you have.

Instead, may I suggest just using a date range for the
entry. Have a Start Date for the activity and an end date.
That will be simpler. It will also prevent you from
duplicating a great dela of data which would use disk
space unecessarily.

If you still want to duplicate the information, post back
and we will give you some assistance.

Kevin

 

[Guest]

I do not have much programming experience. This option
will not be used all the time. Most of the time the sales
reps call on different customers each day. My current
database is working fine and I do not want to add a date
range. All I want to do is duplicate the current record
if the user chooses to do so. Any assistance you can
provide would be greatly appreciated.

Thanks!