K
kealaz
In my form [frmWHEREUSE] there are four fields
PART_NO
NAME
USED_ON
QTY_USED
Before accepting (saving) record, I would like to check that the number in
one of the fields [USED_ON] is an exact value match to a number in our
Drawing Log [TABLE: tblDWGLOG FIELD: PART_NO]. How can I do this? Maybe
an After Update of the field, or upon focus of the next field [QYT_USED]?
Not sure what would be best. Please help with the code I would use. If the
number does not match, I do not want the record to be saved, but instead an
error message should appear.
Thank you so much for your generous time and assistance.
PART_NO
NAME
USED_ON
QTY_USED
Before accepting (saving) record, I would like to check that the number in
one of the fields [USED_ON] is an exact value match to a number in our
Drawing Log [TABLE: tblDWGLOG FIELD: PART_NO]. How can I do this? Maybe
an After Update of the field, or upon focus of the next field [QYT_USED]?
Not sure what would be best. Please help with the code I would use. If the
number does not match, I do not want the record to be saved, but instead an
error message should appear.
Thank you so much for your generous time and assistance.