MS Access, New Rec with previous Rec data

New Rec with previous Rec data

Author	Message
Aspindale Softwar #1 / 3	New Rec with previous Rec data Single form - Access2000 Is the an easier way to assign all the field values from my previous record - into my new rec. I am setting a variable for each field and then passing them across. Seems like there is an easier way? Any help appreciated! Dale
Sat, 20 Sep 2003 01:56:49 GMT

Dirk Goldga #2 / 3	New Rec with previous Rec data One way is to set the DefaultValue property of each data-bound control in the control's (or the form's) AfterUpdate event. -- Dirk Goldgar (remove NOSPAM from reply address) Quote: > Single form - Access2000 > Is the an easier way to assign all the field values from my previous > record - into my new rec. > I am setting a variable for each field and then passing them across. > Seems like there is an easier way? > Any help appreciated! > Dale
Sat, 20 Sep 2003 02:52:34 GMT

Ivo Huizing #3 / 3	New Rec with previous Rec data Check out the 'carry forward' solution by Saicom Systems. It uses the Tag property of a control: http://www.saicomsystems.com/tiparchives.asp Past Issues 1999 Vol 11 Formulate your Forms - Tips for Forms (I) Or download the sample db (A97) directly: http://www.saicomsystems.com/database/form1.zip Grtz, Ivo Quote: >Single form - Access2000 >Is the an easier way to assign all the field values from my previous >record - into my new rec. >I am setting a variable for each field and then passing them across. >Seems like there is an easier way? >Any help appreciated! >Dale
Sat, 20 Sep 2003 03:27:54 GMT

Page 1 of 1

[ 3 post ]