Repeat FORM values from 1 record to next

L

Lisa K-A

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.
 
K

KimTong via AccessMonster.com

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

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)
 
Top