Results 1 to 2 of 2
  1. #1
    angie is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Dec 2013
    Posts
    232

    on change event

    I have afield called FINANCEDPRICE that I wouldlike to create an EVENT on CHANGE
    To add thetotal in the TotalPriceOfAllAddOns to the Financedprice

    Private SubTotalPriceOfAllAddOns_Change()
    End Sub

    Thank you
    Angie


  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
    It is unusual to use the change event, as it fires with every keystroke. More typical would be the after update event. Code might look like:

    Me.FinancedPrice = Me.FinancedPrice + Me.TotalPriceOfAllAddOns

    which would add to the existing amount in that field.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. update/on change event
    By Homegrownandy in forum Access
    Replies: 5
    Last Post: 07-06-2017, 06:57 AM
  2. Event at Record Change
    By Joakim N in forum Programming
    Replies: 2
    Last Post: 10-16-2016, 06:09 AM
  3. VBA Programming for After Change() event?
    By mrmims in forum Programming
    Replies: 5
    Last Post: 07-06-2014, 05:47 PM
  4. On Change event in Text Boc
    By quicova in forum Programming
    Replies: 2
    Last Post: 09-12-2013, 01:27 PM
  5. Any change of focus on form Event?
    By trb5016 in forum Forms
    Replies: 1
    Last Post: 02-11-2011, 08:25 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
  •  
Other Forums: Microsoft Office Forums