Default value from previous record

G

Greg

Is there a way to set the default value to pick up the value from the same
field in the previous record?
 
K

Ken Snell

On the AfterUpdate event of the control that is bound to the field, put this
code:

Private Sub TextBoxName_AfterUpdate()
Me.TextBoxName.DefaultValue = """" & Me.TextBoxName.Value & """"
End Sub
 
K

Ken Snell

Note that you cannot do this in a table, only in a form (see my earlier
reply for how to do this). Which, by the way, is the *only* way you should
be entering/editing/manipulating/viewing/displaying data anyway!
 

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

Split form 0
Change Style to 'Keep with previous' instead of Keep with Next 1
Footer height is different between sections 2
Copy previous record into form field 0
Mail Merge skipping records/sending one at a time 0
Is this possible? 0
Determine if previous "character" is a section break 3
Word macro that can call cells out of Excel for a find and replace 0

Top