I am creating a simple database to hold the stock records for a small shoe shop. I want to be able to enter a barcode into a form and if the record already exists display it/edit it, if not allow users to create a new record. I have been trying to set this up using the on change event for the barcode entry field but I am unsure what is best to use a macro, query or what ??? I have tried all these without success. I should point out that I am completely new to access and never created a database before. Also I have noticed that records seemed to be updated live but I would like updates to take place after a submission button is pressed.

Any help in pointing me in the right direction would be most appreciated.



ps. I am using access 2003