Hi
As title labeled i am trying to update the query results which is sum of another query to a form fields, i did try in putting the reference to QrySumGenralEntry from control source of unbound text boxes something like
for all four fields but it doesn't work.
Then i am trying to do it with sql update query on form's Onchange event like
Can you please help me getting that sumOf values in forms unbound boxes, their is no issues of Unique ID etc because in QrySumGeneralEntry will have only one row at time, which will be sum of mainform's selected ID.
As title labeled i am trying to update the query results which is sum of another query to a form fields, i did try in putting the reference to QrySumGenralEntry from control source of unbound text boxes something like
Code:
=[QrySumGeneralEntry]![SumOfCurDebit]
Then i am trying to do it with sql update query on form's Onchange event like
Code:
UPDATE QrySumGeneralEntry SET QrySumGeneralEntry.SumOfCurDebit = [Forms]![frmJournalEntry]![txtSumCurDebits], QrySumGeneralEntry.SumOfCurCredit = [Forms]![frmJournalEntry]![txtSumcurCredits], QrySumGeneralEntry.SumOfTotalDebit = [Forms]![frmJournalEntry]![txtSumTotalDebit], QrySumGeneralEntry.SumOfTotalCredit = [Forms]![frmJournalEntry]![txtSumTotalCredit];
Can you please help me getting that sumOf values in forms unbound boxes, their is no issues of Unique ID etc because in QrySumGeneralEntry will have only one row at time, which will be sum of mainform's selected ID.