Hello,
Could anyone help me please? I have a subform use as a data entry of
materials for a particular order number. The subform is set to 'continuous
form' as its default view. In the subform I have a 'before update' event
that validates if the new entered material has been entered previously. If
ever the new material entered already exist it will display a notice or
message. What my problem is, I would like to automatically cancel the entry
made then go to the existing record to update.