Results 1 to 2 of 2
  1. #1
    wasim_sono is offline Advanced Beginner
    Windows XP Access 2013 64bit
    Join Date
    May 2005
    Location
    Pakistan
    Posts
    73

    Txt box on form showing 'Balance'

    Dear All

    I'm designing a form for Bank transactions. For this I have fields Debit. Credit, Balance, Cheque no etc.... I need to show the balance in balance field as if user enter amount in Debit field then the balance field minus that amount form Balance field and similarly if he enter amount in Credit field then balance field plus that amount in balance field. I think balance filed should show running total but how I don't know.
    If anyone solve this problem I 'll be very thankful.


    Regards.

    Wasim

  2. #2
    Join Date
    Apr 2006
    Posts
    4
    Dear Wasim;

    As I understood that you have 3 fields debit, balance, credit. So, try to put the following code in Event "After Update" for Credit field:

    [balance]=[balance]+[credit]

    if it work, then try the same with debit but (-) operation.

    Katada

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

Similar Threads

  1. Replies: 4
    Last Post: 08-19-2011, 01:53 PM
  2. fields not showing up in Form view
    By eroy in forum Forms
    Replies: 3
    Last Post: 08-28-2010, 05:44 PM
  3. Data Not Showing in Reports
    By Delin in forum Reports
    Replies: 1
    Last Post: 01-26-2006, 08:53 PM
  4. Adding Running Balance from Form to Reports
    By KIDGEO3 in forum Reports
    Replies: 1
    Last Post: 01-18-2006, 08:52 AM
  5. Null Values not showing up in a Query
    By Valli in forum Queries
    Replies: 0
    Last Post: 01-04-2006, 03:53 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