Repeat FORM values from 1 record to next

[Guest]

I would like to design a FORM where the previous record's values show up
automatically. I know about CNTL '. But I want to do something in the
design mode where 4 of 5 fields just pick up the last record's values.
Thanks for the help.

 

[KimTong via AccessMonster.com]

You use function: =Dlast("[fieldname]","[Tablename]") on default value
property on 4 of 5 fields that you pick.

 

[Douglas J. Steele]

One thing you can try is setting the control's DefaultValue property in its
AfterUpdate event. In that way, the default for the field will always be the
last value saved:

Private Sub MyTextbox_AfterUpdate()

Me.MyTextbox.DefaultValue = """" & Me.MyTextbox.Value & """"

End Sub

You'd have to do this in all 4 of the controls in question. (Note that you
need the quotes even if the field is numeric)