Set Default Value to Previous Value?

[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!

 

[Arvin Meyer [MVP]]

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