Results 1 to 3 of 3
  1. #1
    stoic_bird is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    8

    Move code from button to field

    Hello all

    I have a Form named frnOrder and that form contain a button which has an event code on click.
    I need to delete that button and put its code in the subform "frmOrderDetails" and to let that code take action when the field named "Total" get updated.

    I try to upload my database but no success so I put screen shoots


    Thank youClick image for larger version. 

Name:	111111.GIF 
Views:	19 
Size:	123.5 KB 
ID:	37478Click image for larger version. 

Name:	222222.GIF 
Views:	19 
Size:	63.3 KB 
ID:	37479Click image for larger version. 

Name:	333333.GIF 
Views:	19 
Size:	74.5 KB 
ID:	37480

    Sent from my SM-N900V using Tapatalk

  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,521
    As answered elsewhere, if Total is a calculated field or control its update events don't fire when the value changes. You'd need code in the after update events of the controls involved in the calculation.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,651
    not to mention that nothing will run after the first exit sub.

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

Similar Threads

  1. control button to move through dates
    By sdel_nevo in forum Programming
    Replies: 2
    Last Post: 12-22-2016, 05:18 PM
  2. Replies: 3
    Last Post: 10-20-2014, 03:25 PM
  3. Move a command button?
    By 82280zx in forum Forms
    Replies: 2
    Last Post: 06-16-2014, 04:40 PM
  4. Replies: 2
    Last Post: 02-08-2014, 07:10 PM
  5. Replies: 12
    Last Post: 03-14-2012, 10:54 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