Results 1 to 3 of 3
  1. 07-02-2018, 03:47 AM #1
    jaryszek
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568

    It is possible to call private sub on subform from main form

    Hi,



    It is possible to call private sub on subform from main form?

    Best,
    Jacek
    Reply With Quote Reply With Quote
  2. 07-02-2018, 05:21 AM #2
    isladogs's Avatar
    isladogs
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    Yes - change it to a Public Sub. Then call the sub using code like this:

    Code:
    Me.SubformControlName.Form.SubformEventName
    replacing the parts in red with your actual names
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer
    Reply With Quote Reply With Quote
  3. 07-03-2018, 02:13 AM #3
    jaryszek
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Hi ridders52,

    thank you!

    Best,
    Jacek
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Control on main form is hidden after changing subform recordsource & record navigation in main form
    By Paul1 in forum Forms
    Replies: 10
    Last Post: 07-05-2017, 11:31 AM
  2. Call a SubReport within the Main Report from a Form
    By f15e in forum Reports
    Replies: 5
    Last Post: 02-03-2017, 09:35 PM
  3. main form subroutine ignored by call from sub-form?
    By qajaq in forum Programming
    Replies: 12
    Last Post: 09-15-2014, 04:52 PM
  4. Call a subform event from the main form
    By bonecone in forum Programming
    Replies: 2
    Last Post: 05-02-2012, 11:36 AM
  5. Call a button on the main form from the subform
    By Grooz13 in forum Programming
    Replies: 1
    Last Post: 09-28-2011, 01:15 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums