Subform

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.

This works for me:

210239 How to Use a Bound Control to Find a Record.
Find it at Microsoft's Access Support.
http://support.microsoft.com/default...b;en-us;210239

Andy

"arm" wrote in message
...
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.