Acsess 2007 -2010

[SwartKat]

I have set up a table tblKm with form frmKm: The form is to capture trips driven with a vehicle It has a date with date picker. I have beginKm for the date , a lookup combo box for most popular distances, a lookupcombox for most popular places, and a the table add auto calculates the distance driven as endKm. I want the last record entered as endKm to be the nextrecord beginkm when I click a command button . I have tried many codes such as writing a module or
Private Sub Form_BeforeInsert(Cancel As Integer)
Dim strMsg As Integer
Call CarryOver(Me, strMsg)
If strMsg <> vbNullString Then
MsgBox strMsg, vbInformation
End If

Nothing Work