Results 1 to 2 of 2
  1. #1
    GCS is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2011
    Location
    Swartz Creek, MI
    Posts
    10

    Set Focus on Subform


    I'm sure this is extremely simple, but I am very unfamiliar with VBA so please help.

    I have a form (Auction Lots) with a subform (Auction Items). I would like to focus to go to the first record in the subform when a check box is checked in the main form.

    I know I have to write an event procedure for the check box (Bundle) when clicked. Can anyone help.

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Try this

    In design view, select the Bundle control. In the property sheet, go to the Click event, and click on the ellipsis (...). Insert

    Forms![Auction Items].Setfocus

    If there are other items on the subform, you may need to further qualify the Setfocus.

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

Similar Threads

  1. Moving focus out of the subform
    By injanib in forum Forms
    Replies: 6
    Last Post: 06-20-2011, 03:45 PM
  2. Replies: 0
    Last Post: 04-11-2011, 01:39 PM
  3. Set focus to a field on a subform
    By MiaAccess in forum Forms
    Replies: 11
    Last Post: 03-05-2011, 11:49 AM
  4. Passing focus to subform.....
    By smorelandii in forum Forms
    Replies: 3
    Last Post: 02-04-2011, 10:51 AM
  5. Replies: 15
    Last Post: 11-09-2010, 04:27 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