#Name?

[RossPart]

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

[Bob Fitz]

To save me typing, See: https://answers.microsoft.com/en-us/...b-db90978510d4

[June7]

Me. alias can be used only in VBA, not in textbox.

However, as linked thread posted by Bob indicates, should be able to do this simple sum on form without domain aggregate function.

Is subform in datasheet view? If not, could just show sum in subform header or footer section.

Is Total storing a calculated result?

[Bulzie]

Is this the whole statement? The end of the statement is missing some: DSUM(("Total","tblTransactionDetail","VID= " & me.VID.

Try taking off the Where part to see if it works: DSUM("Total","tblTransactionDetail")

[Welshgasman]

When you get the syntax correct, use the field and not the control.

Text19 is as below, though nothing is shown until I give Text19 focus?

=DLookUp("Steps","tblDates","StepsID = " & [stepsID])