Results 1 to 3 of 3
  1. #1
    rgraben is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Apr 2015
    Posts
    1

    How can I send the cursor to the first field in a form after using the Next Record command?


    I designed a form in Access 2013 which asks for students to sign into a computer lab. Once they've entered the required fields I have a Next Record button on the form which they are instructed to click once finished. How can I make the cursor go to the first field for the next student to sign in, w/o requiring them to click on it themselves?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    Try setting TabOrder property.

    Or maybe need code that sets focus to the control.

    Me.controlname.SetFocus
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    The Tab Order won't do it; when navigating between Records, the cursor stays in the Control that last had Focus before the move.

    June7's code will do it; place it in the Form_Current event:

    Code:
    Private Sub Form_Current()
      Me.controlname.SetFocus 
    End Sub

    Linq ;0)>

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

Similar Threads

  1. Send Single Record From Form
    By kristijo in forum Access
    Replies: 3
    Last Post: 12-02-2014, 06:24 PM
  2. Replies: 2
    Last Post: 02-08-2014, 07:10 PM
  3. Replies: 9
    Last Post: 08-20-2013, 09:59 AM
  4. Replies: 3
    Last Post: 10-19-2012, 04:30 PM
  5. Bold Field by Cursor Position
    By Rawb in forum Forms
    Replies: 4
    Last Post: 02-08-2011, 08:03 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