Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is it possible to go to the field: <company name>

    immedaitely after the button 'Create New Record' is pressed. As l have a lot of fields which the user is required to enter and has to scroll down a lot. Having this facility would make things a lot easier.


    Coding for 'New Record:


    ==================
    Private Sub Command112_Click()
    On Error GoTo Err_Command112_Click


    DoCmd.GoToRecord , , acNewRec

    Exit_Command112_Click:
    Exit Sub

    Err_Command112_Click:
    MsgBox Err.Description
    Resume Exit_Command112_Click

    End Sub
    ================


    Any help would be appreciated

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    You could try

    me.[company name].setfocus

    Immediately after the line that creates the new record.
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •