first delete all data from the meterserial field, so
we can insert the fresh meterserial:
currentdb.execute "update [calibration shee] set meterserial=null"
next open your calibration form on Design view and change
End_User_Name_AfterUpdate() Event.
change this:
meterSerial = DLookup("[NWQIS]", "[CALIBRATION SHEET]", "[END USER NAME]='" & Me![END USER NAME] & "' and [DEPLOYMENT DATE] = #" & Format(dt, "mm/dd/yyyy") & "#")
to:
meterSerial = DLookup("[OWNER] & (' ' + [NWQIS])", "[CALIBRATION SHEET]", "[END USER NAME]='" & Me![END USER NAME] & "' and [DEPLOYMENT DATE] = #" & Format(dt, "mm/dd/yyyy") & "#")