using DlookUp

[ICS]

Please Help I am new at writing expressions in expression builder ,I have a tab form with 3 tabs I am trying to show the totals of job collected from the tabs at the bottom of the first tab. This is what I wrote and I keep getting an #Error.
=DLookUp("[total Travel Hrs]","Time card extended","[SCNID]=" & nz([id],0))
=DLookup(“[Field in Query]”,”[Query]”,”[Field in Query]=”&nz([local ID],0))
Thanks

 

[PNGBill]

It appears your "where" criteria is not pointing to the form control.

Try your access help and search on DLookup. You should see an example of referring to a form control. Form Tab control may be a little different but your code doesn't appear to referr to the form at all.

 

[PNGBill]

Attached "Cheat Sheet" may assist. I think it is from PBaldy
Has been a big help to me.