How to get the balance in a continous form which contains two columns

[khareeda]

date balance out in
05-Oct-09 #Name? 0 100
10-Oct-09 #Name? 4 0
13-Oct-09 #Name? 4 0
14-Oct-09 #Name? 0 50
15-Oct-09 #Name? 4 0
18-Oct-09 #Name? 40 0
19-Oct-09 #Name? 4 0
20-Oct-09 #Name? 35 0
21-Oct-09 #Name? 4 0
22-Oct-09 #Name? 4 0

[ADezii]

date balance out in
05-Oct-09 #Name? 0 100
10-Oct-09 #Name? 4 0
13-Oct-09 #Name? 4 0
14-Oct-09 #Name? 0 50
15-Oct-09 #Name? 4 0
18-Oct-09 #Name? 40 0
19-Oct-09 #Name? 4 0
20-Oct-09 #Name? 35 0
21-Oct-09 #Name? 4 0
22-Oct-09 #Name? 4 0

Check the Control Source for the [Balance] Field and make sure that it is 'Bound' to a valid Field in the Record Source for the Form.

[ajalwaysus]

Ok, this tells us very little. You need to tell us what you are doing with the balance field or what you want it to do with it. Perhaps the underlying code. All I can tell you from what you have shown us is that your balance field is not being referenced correctly, perhaps a bad query, or it isn't bound correctly.

EDIT: What ADezii said =)

-AJ

[khareeda]

I mean the balance is similar to the balance in the bank account statment

in this case the new balance which appear in each row is equal the previous balance +credit-debit

[missinglinq]

And what code are you using to calculate this? We don't have the benefit of having your database in front of us. You need to tell us exactly what you're using to try to do this, in order for us to try to help you! It might be a small adjustment in your current code or it might require a complete remake, but we can't tell with the sparse informationgive n to date.

Linq ;0)>

[NeoPa]

Please take the time to research the problem before you post your question. The experts here are more than willing to help you with a specific problem but you have to do your part to learn the basics and also formulate a specific question we can help with. Please take the time to read over the Posting Guidelines, specifically the section on Before you Post your Question.

Before posting any question you are expected to attempt to find and work on a solution. When you find a specific problem with your attempt, that is the time to post here requesting assistance with any difficulties you have or about a particular function of the code that you don't know how to achieve. When posting your problem, details of the problem itself and where it's found are the bare minimum information required. The experts on this site are more than happy to help you with your problems but they cannot do your assignment/program for you.

Code may be posted for reference purposes, but please don't expect us to work out the meaning of your problem by reverse-engineering your code. The question you post must make sense in its own right.

Please put in a proper question or I will be forced to close this thread.