Results 1 to 3 of 3
  1. #1
    MLangendorf is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2016
    Posts
    50

    Controlling where cursor goes in subform on "Open"


    I created a form that only uses the subform for data entry. I cannot seem to figure out how to get the cursor to go to new record when I open the main form. Subform is a datasheet view.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    in the main form current event put

    Me![putyourSubformControlNamehere].SetFocus
    DoCmd.GoToRecord , , acNewRec

  3. #3
    MLangendorf is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2016
    Posts
    50

    Perfect

    This worked perfectly and took me about 30sec.
    Many thanks "Ajax"


    Quote Originally Posted by Ajax View Post
    in the main form current event put

    Me![putyourSubformControlNamehere].SetFocus
    DoCmd.GoToRecord , , acNewRec

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

Similar Threads

  1. Can't test code - "Debug" - "Run to Cursor"
    By GraeagleBill in forum Programming
    Replies: 4
    Last Post: 05-15-2016, 05:16 PM
  2. Replies: 5
    Last Post: 05-06-2016, 11:43 AM
  3. Replies: 2
    Last Post: 01-04-2016, 04:44 AM
  4. Replies: 3
    Last Post: 02-06-2015, 03:22 PM
  5. Controlling the use of an "Other" field with VBA
    By ResearchRN in forum Programming
    Replies: 7
    Last Post: 11-29-2011, 03:42 PM

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