Results 1 to 5 of 5
  1. #1
    Mclaren is offline Competent Performer
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164

    run button on parent form

    I need to run a button on a parent form on an after update event on the subform.



    Using access 2003

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Make sure it's public, then

    Call Forms!FormName.ButtonName_Click
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Mclaren is offline Competent Performer
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164
    No luck, i am not sure if i am doing something wrong, this is what i have

    MainForm1, has 2 Subforms: SubformA and SubformB (both in datasheet view)
    Subform A a coloum whos field is set to a general number field. if i update info in said field, after i exit from that field to either the next column or next entry for same field then i want to execute a button on mainform1 which will refresh the data in subformB (also a datasheet subform).

    I do not get any error messages with the code provided, its just that nothing even happens. If i click the button myself then the data updates. this is rather cumbersome as i don't think all users will catch on to the fact they must click the button (ID-10-T users).

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Try without the Call. I just tested this successfully:

    Forms!frmEmployee.cmdOrderReport_Click

    If it's still not working, can you post the db?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Mclaren is offline Competent Performer
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164
    Came right, it was callig the function fine, but the function did not work correctly.

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

Similar Threads

  1. Parent/Child Append Question
    By davidson12 in forum Access
    Replies: 6
    Last Post: 01-15-2015, 08:15 PM
  2. Replies: 1
    Last Post: 03-03-2010, 07:29 PM
  3. Parent/Child subform
    By Jerry8989 in forum Forms
    Replies: 1
    Last Post: 09-18-2009, 07:27 AM
  4. SubForm to Parent
    By henryclay in forum Forms
    Replies: 2
    Last Post: 11-15-2006, 09:44 AM
  5. SubForms to Parent
    By henryclay in forum Forms
    Replies: 2
    Last Post: 10-27-2006, 07:14 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