Results 1 to 4 of 4
  1. #1
    protean_being is offline Novice
    Windows XP Access 2003
    Join Date
    May 2008
    Posts
    9

    Form Event Question

    When I update/add a record on a form and push the next record button the focus is still on the last field that I edited. Which event is triggered when the next record is selected so I can insert the vba code:

    me![First Field].setfocus

  2. #2
    Join Date
    May 2008
    Posts
    8
    If you are just moving from record to record, your "Tab Order" under the View menu for the form should control this; the focus should go the the first field.

    If you are doing something special because a record is new (or not), then you have to specify the condition in the Form Current event.

    I often use:

    If Me.NewRecord Then ClassYear.SetFocus

    - K-Squared

  3. #3
    protean_being is offline Novice
    Windows XP Access 2003
    Join Date
    May 2008
    Posts
    9
    I know the code to use. Where do I put it?

  4. #4
    Join Date
    May 2008
    Posts
    8
    Quote Originally Posted by protean_being View Post
    I know the code to use. Where do I put it?
    In the "Current" event.

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

Similar Threads

  1. Question on Northwind catagories form
    By Icedog in forum Access
    Replies: 1
    Last Post: 09-25-2008, 08:10 AM
  2. form_current event question
    By edo in forum Forms
    Replies: 0
    Last Post: 09-08-2008, 02:54 PM
  3. Befor update event
    By wasim_sono in forum Forms
    Replies: 1
    Last Post: 03-24-2006, 07:21 AM
  4. Replies: 1
    Last Post: 02-27-2006, 07:46 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