Set Default Value to Previous Value?

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

Guest

Hi,

Is there a way to set the default value so that it displays the value in the
previous record?

The table is 'data'
The field is 'complainers'

Thanks!
 
This will only work after you've made an entry in an open form. Do not work
in tables. Tables are for storing data, queries are for retrieving and
manipulating data, forms are for entering and searching for data, and
reports are for reporting (printing) data.

In a form's Before Update event write a procedure, like:

Sub Form_BeforeUpdate(Cancel As Integer)
Me!complainers.DefaultValue = """" & Me!complainers.Value & """"
End Sub
 
Back
Top