Most recent value in a field

  • Thread starter Thread starter PsyberFox
  • Start date Start date
P

PsyberFox

Hi there,

I have an Access front-end running input screens, etc for some linked SQL
tables. Is there a way to populate a field on an input screen (setup as a
form), to the last value entered for the previous record?

Thank you in advance!
 
The most common way is to use the control's Default Value property. Set the
Default Value property to the current value in the control's After Update
event.

Private Sub MyControl_AfterUpdate()
Me.MyControl.DefaultValue = Me.MyControl
End Sub
 
Back
Top