Preventing Changes/Additions except through appropriate form/table?

[MarcieFess]

You are all so helpful! I would be sooo lost without this forum. Thanks everyone for your help.

I'm chugging right along now with this project with the grocery stores. I found an issue by mistake yesterday.

While I was trying to test one of my forms (which was NOT working and I had to totally redesign it), I somehow created a bunch of stores in my Store Information table...some with no names, some with the first letter of an existing store, and there was even a duplicate of the store which is creating a problem now because some products exist in Store 1A and others exist in Store 1B.

I've created a query to identify the wayward products and am changing those. I'll delete that store then.

My issue is...can I set it so that the ONLY place a new store can be created is in the Store Information Input form? That if someone makes a typo when entering products, it doesn't create a new store?

Thanks again for everyone's help. I am so much more confident today than I was yesterday!

Marcie Fessler
Access 2010

 

[gemma-the-husky]

you have partially entered stuff into your form. when you close th e form, or move to another record the partial records get saved.

this is standard access behavior, and best kept

the way to manage this is to make the fields in the table "required = true", and "allow zero length = false". add a suitable unique key to prevent duplicates

you can also use code in the before update event to test and validate the data in the form.

these processes will prevent the partial records being completed and saved.

 

[MarcieFess]

Thank you. When the other person working in the database leaves early today I'm going to make those changes. Thanks!