Validate for duplicate values during data entry
Posted on 2004-08-20
frmAddMedication allows a user to select a med, enter dosage, date, dr. Before the record is saved I want to check to ensure that resident is not already on that med. This form is bound to tblResidentMedication. Investigating the before update event looks great however, I am just not sure how to code.