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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeat Field Value 3
Repeat field value in next field 3
Lookup a value in a table and display text if a value exists 1
Could not update; currently locked (updated post) 6
Default Value - Recent Entry 1
Repeat field value 3
Problem inserting time values from Access into SQL Server 5
not null 1

Back
Top