Results 1 to 2 of 2
  1. #1
    Aimee is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    19

    Question Adding a macro to a form navigation button

    In a form, I would like the cursor to go to a specific control when I click 'New (blank) record'. I have looked in the list of event properties but cannot see anything regarding 'New (blank) record'. Does anyone know how to go about doing this?



    Thanks

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    This is untested, but you could try something like the following code in the forms On Current event:
    Code:
    If Me.NewRecord = True then
     Me.NameOfYourControl.SetFocus
    EndIf
    You would need to change NameOfYourControl
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Assign converted macro to navigation panel button
    By nhylan in forum Programming
    Replies: 4
    Last Post: 04-17-2013, 01:33 PM
  2. Replies: 3
    Last Post: 11-15-2011, 06:29 PM
  3. Print Button on a Navigation Form
    By sotssax in forum Forms
    Replies: 2
    Last Post: 09-15-2011, 07:47 AM
  4. Replies: 0
    Last Post: 01-12-2011, 12:43 PM
  5. Adding Command Button To Form
    By uneek78 in forum Forms
    Replies: 7
    Last Post: 03-27-2009, 07:43 PM

Tags for this Thread

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