D
DavidS
I've tried every way possible to figure this one out.
ItemNo is a text value on the record.
GraphedID is a numeric long on the record.
I call this from a record in acontinuous subform,
looking for a max value from among that subform's records.
Dim LastLocation As Integer
LastLocation = DMax("[DefectLocation]", "tblDefectsGraphed",
"ItemNo = " & [ItemNo] & " And GraphedID > " & [GraphedID]")
Continue to get "Type mismatch in expression"
I've tried many combinations of quoting and combinig these
elements. Also tried several solutions I found in the Google
Groups, but no luck.
Any suggestions?
Thanks
Steve
ItemNo is a text value on the record.
GraphedID is a numeric long on the record.
I call this from a record in acontinuous subform,
looking for a max value from among that subform's records.
Dim LastLocation As Integer
LastLocation = DMax("[DefectLocation]", "tblDefectsGraphed",
"ItemNo = " & [ItemNo] & " And GraphedID > " & [GraphedID]")
Continue to get "Type mismatch in expression"
I've tried many combinations of quoting and combinig these
elements. Also tried several solutions I found in the Google
Groups, but no luck.
Any suggestions?
Thanks
Steve