#name? Error

[dragnsteph]

This seems to be one of the most common problems but I can't seem to figure mine out, even with all the posts and responses, so I'll post mine here and see if you guys can tell me what to do maybe then I can keep my hair. :banghead:

=DLookUp("SumOfHoursWorked","qryHoursWorkedAllTime","NameID = " & [qryHoursWorkedAllTime]![NameID])

I suspect I either 1) don't have something bound correctly, which confuses me so if that's the problem I will maybe need a little handholding... or 2) the NameID names are conflicting?

So far as I can tell the form is bound to the tblVolunteers table which has the NameID field in it. The query also has this field, and it works - it returns a listing of SumOfHoursWorked by NameID.

 

[pbaldy]

Try

=DLookUp("SumOfHoursWorked","qryHoursWorkedAllTime","NameID = " & [NameID])

 

[dragnsteph]

Wow! That... worked. So I don't need to specify which NameID, it's OK that they are the same?

Thank you so much

 

[pbaldy]

Happy to help! The one outside the concatenation will come from the form. You were referring to a query, which the form didn't know anything about.