Dsum in Tabbed Form

  • Thread starter Thread starter gator
  • Start date Start date
G

gator

I have a form in Tab form where I want to show a total in the footer of the
Receipt# of the current record. One record may have a distinct number or
several records could have the same receipt number. I'm thinking something
like...

DSUM("Amount","TableName",ReceiptNumber=ReceiptNumber)

ReceiptNumber is a Number format in the table.

Will this work in the tab form?
 
In current event of form-
me.[yourtextbox] = DSUM("Amount", "TableName", "ReceiptNumber = " &
[ReceiptNumber] )

Damon
 
Back
Top