Results 1 to 2 of 2
  1. #1
    Grooz13 is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    97

    Call a button on the main form from the subform

    Ok I have a Form



    Command
    and a subform
    Order

    I use the subform to order some mats to get the job done and I want the production_date on the Command Main form to be the latest date from the subform field Reception_Date to be my production date...

    So I did a button on the main form(Command) that does this..BUT!

    I want to enter some code in the On change Reception date from the subform to call my button code... and I can't do it...

    sorry for my english

    thank you

  2. #2
    Dan is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    15
    If these are bounded to a database tables, then use the AfterUpdate event to make sure the subform value is saved to your associated table, then you can update the Product table field directly and your bound Production textbox should update to reflect the change me thinks.

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

Similar Threads

  1. Form command button to do something/call function
    By shubhamgandhi in forum Programming
    Replies: 2
    Last Post: 07-27-2011, 04:45 PM
  2. Controlling Subform from Main Form
    By SteveF in forum Forms
    Replies: 5
    Last Post: 07-01-2011, 05:32 PM
  3. Subform in a Tab Control on a Main form
    By jpkeller55 in forum Access
    Replies: 4
    Last Post: 01-08-2011, 12:31 PM
  4. Replies: 0
    Last Post: 07-26-2010, 04:36 PM
  5. Subform vs main form calculation
    By fadone in forum Forms
    Replies: 17
    Last Post: 12-21-2005, 07:27 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