I have a table - tblVoucher which is like a 'Header' table. It has a field called VID (VoucherId) which is an Autonumber Type
I have a table - tblTransactionDetail which contains many lines related to the tblVoucher table via VID which is a number type and LID (LineId), an Autonumber type, and a field called Total which is currency type.
There is a relationship which Links the two VID fields from each table.
PROBLEM:
subformTransactioDetail (part of frmVoucher) lists Line Items by [LID] for each [VID]. on frmVoucher. I have a field on frmVoucher called 'VoucherTotal' which = DSUM(("Total","tblTransactionDetail","VID= " & me.VID.
The result in VoucherTotal is "#Name?"
I think I'm 95% there, but cannot see the problem.
PLEASE HELP