Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I think I goofed because I was copying/pasting from another source. I should have written
    Code:
    Forms![NameOfMainForm]![NameOfSubformControl].Form![FormControlName].SetFocus
    Note: don't confuse subform control name with the name of any forms. It has to be the name of your subform control.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  2. #17
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Let's try something simpler. Let's put this code in the subform's FORM_CURRENT event.
    Code:
    Private sub Form_Current
        Me.Land_Irrigation_Details.Setfocus
    End Sub
    You would need to put this in all 10 subforms. Land_Irrigation_Details is the field you wish the cursor to reside in, as per the example shown.

  3. #18
    vaibhav28 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2016
    Posts
    9
    Quote Originally Posted by davegri View Post
    Let's try something simpler. Let's put this code in the subform's FORM_CURRENT event.
    Code:
    Private sub Form_Current
        Me.Land_Irrigation_Details.Setfocus
    End Sub
    You would need to put this in all 10 subforms. Land_Irrigation_Details is the field you wish the cursor to reside in, as per the example shown.
    Thanks much, but still not working!! I have but this code in Form Load, Form Current event but it doesn't seem to fire.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Email Updates Not Working Properly
    By quirkyd in forum Import/Export Data
    Replies: 1
    Last Post: 10-26-2014, 09:24 AM
  2. Checkboxes not working properly
    By TK03 in forum Access
    Replies: 1
    Last Post: 12-24-2012, 09:04 AM
  3. Login form is not working properly
    By papa yaw in forum Forms
    Replies: 1
    Last Post: 12-19-2012, 05:25 PM
  4. Replies: 8
    Last Post: 08-26-2012, 11:11 PM
  5. Count or DCount Not Working Properly
    By Chris1112 in forum Forms
    Replies: 3
    Last Post: 05-09-2012, 02:51 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