How to repeat data from previous rec 
Author Message
 How to repeat data from previous rec

What do i need to code in the properties sheet for a field or form to
automatically copy the data from the previous rec into the fields on the new
record?  I have about 15 fields to enter on a data entry form, and I would
like to have 4-5 of those fields automatically show the values from the
previously entered rec.

I know there is a quick key combo that the user can use, ie - CTRL+";
however, I would like the data to show up without their intervention

Any suggestions?
TIA

--
Cheryl C.



Thu, 23 Jun 2005 08:01:17 GMT  
 How to repeat data from previous rec
I think this would work:

Create a hidden control on the form to hold a hopy of the previously
entered value in each control you'll want to copy.  Set the default
value property of the original controls to =[<datacopyctl>], then
wrtie code on BeforeUpdate of the form to copy the current values into
the "copy" controls.

On Sun, 05 Jan 2003 00:01:17 GMT, "c christopoulos"

Quote:

>What do i need to code in the properties sheet for a field or form to
>automatically copy the data from the previous rec into the fields on the new
>record?  I have about 15 fields to enter on a data entry form, and I would
>like to have 4-5 of those fields automatically show the values from the
>previously entered rec.

>I know there is a quick key combo that the user can use, ie - CTRL+";
>however, I would like the data to show up without their intervention

>Any suggestions?
>TIA



Thu, 23 Jun 2005 08:17:35 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. how to repeat data from previous rec

2. New Rec with Data Based on Previous Rec's Data

3. New Rec with previous Rec data

4. New Rec with previous Rec data

5. Repeat data from previous record

6. Repeat same data from previous fields?

7. Copy previous fields from previous record during data entry

8. Perform a go to new rec w/ retaining some info from prev rec

9. Move to newrecord adds rec to db, but cant move to new rec

10. changes to all records in one rec set based on position in another rec set


 
Powered by phpBB® Forum Software © phpBB Group