Results 1 to 2 of 2
  1. #1
    sekoma is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Posts
    1

    continuous form calculate balance

    hi
    the form contain combo box that linked with sub form continuous contain amount + balance , so i want record by record give me balance foe exam: for first record i add amount 5 $ it equal balance for second record when i add amount 10 $ the balance field =5+10=15 and third add amount 2$ the balance =15+2=17 that's like the attach photo
    regards

    Click image for larger version. 

Name:	Untitled.jpg 
Views:	15 
Size:	99.4 KB 
ID:	48172Click image for larger version. 

Name:	Untitled1.jpg 
Views:	16 
Size:	146.2 KB 
ID:	48173Click image for larger version. 

Name:	Untitled3.jpg 
Views:	15 
Size:	105.0 KB 
ID:	48174
    Last edited by sekoma; 06-30-2022 at 02:38 AM. Reason: change

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,914
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Calculate bank account balance
    By dougdrex in forum Queries
    Replies: 8
    Last Post: 11-28-2014, 01:59 PM
  2. Replies: 2
    Last Post: 09-04-2013, 09:48 AM
  3. How to calculate current balance on hand
    By fazly lee in forum Access
    Replies: 11
    Last Post: 09-05-2012, 09:16 PM
  4. Replies: 12
    Last Post: 06-10-2011, 10:19 PM
  5. Replies: 0
    Last Post: 02-15-2009, 09:14 PM

Tags for this Thread

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