DLookUp Total Sale from Access Template

[guest]

Hi

I have the following in the control source of a text box in a custom form within the MS Access Purchasing Database Template

=DLookUp("[Total Sale]","[Forms]![Orders by Customer Subform]","[OrderID]='" & [Forms]![Orders by Customer Subform]![OrderID] & "'")

I want to lookup the total sale of an OrderID from the Orders by Customer subform.

Can anyone see anything blatantly wrong with this?

Thanks

 

[Norie]

I take it this is on the main form?

If so I think your reference to the subform is wrong.

Have a look at the Access Help for subforms>referring to in expressions.

I think you need something like this:

[Forms]![Main Form]![Orders by Customer Subform].Form![OrderID]

Where Main Form is the form that the subform is on.

 

[guest]

Thanks for the assistance, I have amended the line to read:

=DLookUp("[Total Sale]","[Forms]![Orders]![Orders by Customer Subform].Form","[OrderID]='" & Forms!Orders![Orders by Customer Subform].Form!OrderID & "'")

But am receiving a #name error.