Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    QuantifyRisk is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    65

    Thanks, June7. You've help me out a bunch of times already. Take a break.

  2. #17
    QuantifyRisk is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    65
    Ok, so I created a new button for the sub-form to just call parent instead of sub-sub-form calling parent.parent. Same error 438 issue. Any idea why it would have this problem setting the focus to a parent form?

  3. #18
    QuantifyRisk is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    65
    I fixed it!

    Me.Parent.Parent!Comments.SetFocus
    DoCmd.GoToRecord , , acNewRec

    I had it as:

    Me.Parent.Parent.Form!Comments.SetFocus
    DoCmd.GoToRecord , , acNewRec

    and that's what caused days of headaches. Thank you June7 for your help.

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

Similar Threads

  1. Form validation before saving
    By BDevil15 in forum Access
    Replies: 3
    Last Post: 09-01-2014, 07:22 AM
  2. Form not saving records
    By jree3000 in forum Forms
    Replies: 9
    Last Post: 06-17-2014, 07:01 PM
  3. Replies: 10
    Last Post: 10-22-2013, 07:35 AM
  4. saving a form
    By Ray67 in forum Forms
    Replies: 11
    Last Post: 10-23-2011, 06:45 PM
  5. Closing and saving a form
    By Lxmanager in forum Forms
    Replies: 14
    Last Post: 11-21-2010, 02:04 AM

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