Same data in the next record

  • Thread starter Thread starter Tim
  • Start date Start date
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
 
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.
 
Back
Top