Copying from previous record to current

[Mark S]

I am using version 2002. I thought this would be easy but my every attempt
results in a halt error with each try.

I have a subform that contains about 10 text or memo fields. Each record
represents a visit.

When I create a new record (visit) in the subform I would like to copy
information from the previous record into the current new record. I could
just highlight it copy and paste but thought that a command button driving a
macro would be easiest and fastest for the users I am trying to help.

Can I do that with a macro? Any hints apprecited. For example control
cardiac in subform I would copy the written note into the current record and
then edit to add to it if needed. In many cases the information is the
sample - the visit from yesterday is the same. Thanks.
*****************************************
Mark M Simonian MD FAAP
681 Medical Center Dr West #106
Clovis, CA 93611
(559) 325-6850
www.markmsimonian.medem.com

 

[Mark M S]

I created an append query that looked at a "selected" record field. I
indicated the date()-1 for the previous day in the currentDate field.

In the macro i used OpenQuery to the append query. I then followed with a
Requery. I deselected the CurrentDate and CurrentTime field so that could be
updated to the current date and time after the macro ran. I then created a
command button and attached the macro to the Click event.

It seems to be working. This gives me a copy and paste for all the text and
memo fields for the previous day and then the attending physicians can add
any additions.
*************************************************
Mark M Simonian MD FAAP
Medical Director, ChildNet Medical Assoc.
681 Medical Center Drive West #106
Clovis, CA 93611
(559) 325-6850
www.markmsimonian.medem.com
****************************************
Alert: This email and any files transmitted with it
are intended solely for the use of the individual or
entity to whom they are addressed and may contain
confidential, patient health or other legally
privileged information. If you have received this
email in error please notify the sender by email,
delete and destroy this message and its attachments.
Any unauthorized review, use, disclosure,
or distribution is prohibited.