VBA to avoid duplicate supplies item

[hfsitumo2001]

you just change txt_ItemCode in the code with ItemCode.

HI Arnel,
In reference to Pat's comment about RI ( Referential Integrity) in my database, I want to try to change the control name to be "txt_ItemCode". But since my database is already go live since Mar 2021. What do you think that I am so careful in order not to have a problem on my database.

My testing database is non split one, while I have made much form modifications in my live database ( the split one). Can I import the forms & Reports from my live database and replace it?, I think this is the best way.

Thank you for your advice.

Frank