When moving to new Data Entry record, make certain fields same as prev 1

[pdbowling]

Hi all.
I have a form that autostarts at 'New Record', so it starts out blank except for default values in the table design. I would like to have a 'Next' Button that goes to the next new record and autofills certain fields with the same data that was just entered in the previous record (most of the data entry is done in related batches so some fields remain the same for a long while). Any suggestions on how to accomplish this?
Thanks everyone.
PB

 

[gol4]

there are servel other options but the way I find the easiest is to utilize the default value propery to your advantage

in each fields you want to carry over after update event place code something like

Me.fieldname.DefaultValue = "'" & Me.fieldname.value & "'"

for a date field change the ' to a #
Me.fieldname.DefaultValue = "#" & Me.fieldname.value & "#"

will not carry over when a new form is opened
good luck

 

[jwhjr]

gol4
Worked perfectly for me, have a star!

JR