locked
Access 2013 RRS feed

  • Question

  • I created a form called frmPubsMainTable and a subform called frmJOINPubsMainJournalAuthorsubform.  I would like the field in the main form "FirstAuthorID" when update with data to auto-fill the "AuthorID" in the subform. 

    This is my code but I keep getting this error: Compile error: Method or data member not found

    Private Sub FirstAuthorID_AfterUpdate()
    Me.frmJOINPubsMainJournalAuthorsubform.AuthorID = Me.FirstAuthorID
    End Sub

    Thanks!

    Thursday, June 22, 2017 1:48 PM

All replies

  • See if the below link helps:

    http://access.mvps.org/access/forms/frm0031.htm


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Thursday, June 22, 2017 2:01 PM
  • Hi akearse,

    Has your issue been resolved?

    If not, I suggest you try below code.

    Private Sub UserName_AfterUpdate()
        Me!tblUserSubform!Text8.SetFocus
        Me!tblUserSubform!Text8.Text = Me.UserName
        Me.UserName.SetFocus
    End Sub

    In addition, your issue is more related with Access, I will move this thread to Access Forum.

    Reference:https://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev

    Best Regards,

    Edward


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, June 29, 2017 9:07 AM