Problem with Dsum in TextBox 1

[rccline]

I am at a loss to get Dsum to work on my form.
FieldName represents a number.

=Dsum("[fieldname]","[qryName]", "[criteria]")

where the critea is "[FieldName2]=[form name].Form![control name]

If I use as criteria: "[FieldName]=1" I get an answer.
If I use the following criteria, I get Error as a result.

=Dsum("[FieldName]","[qryName]", "[FieldName]=[form name].Form![control name]")

I need to show the sum of the [FieldName] where the form is showing the record ID displayed in [control name] on the form.



Thank you.

Robert

 

[PHV]

=Dsum("[FieldName]","[qryName]","[FieldName]=" & Forms![mainform name]![control name])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[rccline]

Yes! Thank you PHV.

Robert