Same data in the next record

T

Tim

I need the ending reading in one record to = the beginning
reading in the next blank form
ending milage on the last form should = the beginning
milage reading on the next new record
Thanks
 
J

John Vinson

I need the ending reading in one record to = the beginning
reading in the next blank form
ending milage on the last form should = the beginning
milage reading on the next new record
Thanks
Click to expand...

Put some VBA code in the AfterUpdate event of the [ending milage]
textbox on the Form:

Private Sub txtEndingMilage_AfterUpdate()
Me!txtBeginningMilage.Default = Chr(34) & Me!txtEndingMilage & Chr(34)
End Sub

using, of course, your own control names.
 
Top