Dlookup probem

[Gina Maylone]

I think I am losing my mind. I have written hundreds of dlookup/dlast/dfirst statements, and this one refuses to LOOKUP! All I get is flashing error

=DLast("AddendumNum","addendums","jobnum=me.jobnum")

. Have tried several variations of the criteria. Have verified all names and spelling. Have verified there is data. Have created a query to display the last addendum number. Have deleted the field and created a new one. Have repaired and compacted. Anyone?

[JoeM]

For your Criteria argument (the last one), use:

"jobnum=" & [jobnum]

[Gina Maylone]

OMG! Thank YOU!! Joe M! You SAVED my sanity!!!!