Share via

DoCmd.GoToRecord , , acNext error message

Anonymous
2018-02-08T10:21:07+00:00

I have the following code to check information is entered in a form and it has worked in the past but I am now getting a message that I cannot move to specified record.  Any help would be appreciated

If Not IsNull(Me.[Review Type]) Then

            If MsgBox("Are you sure this is not a full file review?", vbYesNo) = vbYes Then

            DoCmd.GoToRecord , , acNext

            End If

        Else

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. ScottGem 68,810 Reputation points Volunteer Moderator
    2018-02-08T12:53:22+00:00

    DoCmd.GotoRecord is old code.  Try DoCmd.RunCommand acCmdRecordGotoNext  (not sure if that's the correct constant but you should be able to find the correct one using Intellisense)

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-02-08T16:19:09+00:00

    Thank you used acCmdRecordsGoToNext and that fixed it 👍😁

    0 comments