Results 1 to 2 of 2
  1. #1
    asmith78 is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Aug 2011
    Posts
    15

    HELP! Set Focus to Continuous Sub Form Field


    Hello all,

    I am setting the focus to a field on the subform of the main form (screen shot attached) behind the On Click event procedure of the Add Error button of the main form.

    I know how to set focus to the "Who Commited the Error?" field on my continous subform (see attached screen print)....however, the problem is it only works for the first error. Then if you add the second, it sets focus to the field but on the first error assigned not the second.....

    Any ideas how to correct this?

    Thanks a million,
    Amy
    Last edited by asmith78; 09-09-2011 at 02:09 PM. Reason: Add attachment

  2. #2
    asmith78 is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Aug 2011
    Posts
    15
    Nevermind! I figured it out! Got to love Google! I just had to add:

    DoCmd.GoToRecord, , acLast

    after the setFocus coding! :-) YAY!

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

Similar Threads

  1. Replies: 12
    Last Post: 06-10-2011, 10:19 PM
  2. Set focus to a field on a subform
    By MiaAccess in forum Forms
    Replies: 11
    Last Post: 03-05-2011, 11:49 AM
  3. Replies: 6
    Last Post: 02-09-2011, 07:30 AM
  4. Calculated Field in continuous form
    By doobybug in forum Forms
    Replies: 2
    Last Post: 11-15-2009, 08:54 AM
  5. Replies: 2
    Last Post: 05-22-2009, 01:07 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