Repeat FORM values from 1 record to next

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
You use function: =Dlast("[fieldname]","[Tablename]") on default value
property on 4 of 5 fields that you pick.
 
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)
 
Back
Top