Search results

thanks i understand at your information and it solved correctly Thank you

im using the dsum in vba BALANCE = DSum("[Amount]", "[QDRDE]", "[INVONO]=" & Me.INVONO) but i see all balance calculated for all account , so thats I want when i change Unbound cbo.MRC in the main form the subform updated and the balance must calculate only for this account that's show in...

Thx all for replay pat hartman how is it too easy can you explain how i can do this with whitch way regards

I mean like this attach photo I taken a pic from other data base

thanks for replay i know create reporting for sub form, and the subform it be add or edit data. 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...

Thanks all i need this calculation in form because i have data base it contains combo box it linked with subform the subform its view as worksheet ,so in sub form i have amount field and balance when i type a mount it be calculate in balance like excel sheet

i have access continuous form with 2 fields i want calculate sum like this ((first record when i type data1 field1 its =data1 field2 and second record data2 field2 =data1 field2 +data2 field1 ,third record data3 field2 =data2 field2 +data3 field1 and it courteous automatically how to do this in...