DLookup("[PVIN]", "tblPreliminary VINs",
"[PVIN]=Forms!frmVINOD O!SerialNum")
is giving me a Type Mismatch error. That's confusing to me
and I don't know how to circumvent it. The [PVIN] field in
tblPreliminaryV INs is a 17-char text field. Forms!frmVINODO !SerialNum
is just an unbound textbox on a form (frmVINODO).
I run the DLookup during the textbox's BeforeUpdate event code. Some
VIN values I type in there do NOT give rise to the error. Some do. By
nature, the VIN values are alphanumeric. Should I be wrapping the
Forms!frmVINODO !SerialNum in CStr( ) or something?