GoToRecord acGoTo

[Ruegen]

not sure what is wrong

ID field is stored in varIDPrevious

if the record is not completed I have it going to

DoCmd.GoToRecord , , , acGoTo, varIDPrevious

however I get an error and nothing changes

the idea is that if you move a record away it will go back to it.

[Ruegen]

Nevermind

I wasn't using me.current record

varIDCurrent = Me.CurrentRecord


If varIDCurrent <> varIDPrevious Then
    If IsNull(Me.txtEnterMemo) = False Then
    
    With Me.Recordset
    DoCmd.GoToRecord , , acGoTo, varIDPrevious
    MsgBox "you cannot move to another record until you have entered or cleared the communication memo field"
    End With


    Else
        varIDPrevious = varIDCurrent
    End If
End If