Results 1 to 3 of 3
  1. #1
    aamer is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Location
    Pakistan
    Posts
    276

    Code Request For Text Box After Update

    On a form a text box "GSTRATE" has the following calculation in control source


    =(([Purchase Price]*[Purchase Sales Tax])+[Purchase Price])


    what code do i write on After Update Event so the result is stored in PurGSTRate field of "purchases" table

  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
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    aamer is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Location
    Pakistan
    Posts
    276
    this article helped and have solved to save the calculation in a field of PURCHASES table
    used the following

    Private Sub Prctxt_AfterUpdate()
    PGST = Round(([Purchase Price] * [Purchase Sales Tax]) + [Purchase Price], 4)
    End Sub




    Private Sub PGST_AfterUpdate()
    Call Prctxt_AfterUpdate
    End Sub

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

Similar Threads

  1. Replies: 5
    Last Post: 12-21-2018, 01:55 PM
  2. Replies: 2
    Last Post: 08-03-2017, 04:58 AM
  3. update VBA 2.0 code in forms into access 7.0 code
    By toughwg in forum Programming
    Replies: 1
    Last Post: 12-08-2015, 11:40 AM
  4. Replies: 2
    Last Post: 06-28-2013, 12:58 PM
  5. Code donation request
    By dixonada in forum Programming
    Replies: 2
    Last Post: 04-23-2012, 04:33 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