A
arm
Could anyone please help me. I have this subform use for entering materical
code, uom, price, etc. In the 'Before Update' event of the subform it
checks if the user have entered a duplicate material code. If he/she did
entered a duplicate material code it displays a message. What I would like
to happen after he/she click the 'OK' button from the displayed message
window it will auto-cancel the current entry and move to the record with the
existing material code. For now what the user does he/she press the <ESC>
key (several times) to cancel the new entry and search for existing material
code.
code, uom, price, etc. In the 'Before Update' event of the subform it
checks if the user have entered a duplicate material code. If he/she did
entered a duplicate material code it displays a message. What I would like
to happen after he/she click the 'OK' button from the displayed message
window it will auto-cancel the current entry and move to the record with the
existing material code. For now what the user does he/she press the <ESC>
key (several times) to cancel the new entry and search for existing material
code.