Results 1 to 3 of 3
  1. #1
    rbiggs is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2011
    Posts
    23

    Navigation Error

    I have a form that by defaults opens so the user can enter a new record. The form also has buttons to flip through the records. After the form us opened and the user enters the new record both the next and previous buttons trigger error #2105. I get why the next button triggers this error. However I don't understand why the previous button does. The code below is on the on click event of the previous button.

    Private Sub Previous_Invoice_Click()
    On Error GoTo Err_Handler
    DoCmd.GoToRecord , , acPrevious
    Exit Sub
    Err_Handler:


    If Err.Number = 2105 Then
    MsgBox "You do not have the ability to navigate to the specified record", vbInformation
    Else
    MsgBox Err.Description, vbExclamation, "Error #: " & Err.Number
    End If
    Exit Sub

    End Sub

    Any suggestions would be appreciated.

    Thanks

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    probably because the form is in data entry mode. there are no prev or next records in that mode. it's probably one at a time only.

  3. #3
    rbiggs is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2011
    Posts
    23
    Any suggestions how how to get around this?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Navigation Form
    By rkalapura in forum Forms
    Replies: 3
    Last Post: 07-29-2011, 11:33 AM
  2. Navigation Form
    By Roger81 in forum Forms
    Replies: 2
    Last Post: 07-21-2011, 01:33 AM
  3. Navigation form
    By Wayne311 in forum Programming
    Replies: 10
    Last Post: 02-10-2011, 01:06 PM
  4. Help with navigation
    By phelpsville in forum Access
    Replies: 0
    Last Post: 04-16-2010, 07:33 PM
  5. Navigation Code
    By henryclay in forum Forms
    Replies: 2
    Last Post: 11-15-2006, 09:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums