Subform

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup in subform 11
Synchronize Form and Subforms. Second Subform is the problem. 0
Check for Duplicate Records 7
Auto filling fields in a sub-form (Access 2003) 1
Autonumber is reusing previously assigned numbers-creating duplica 4
Data entry VBA 1
Data entry to table from a form 0
Event order when clicking away from a field 8

Top