I think that in my post #3 I have not explained well what I meant.
I meant to directly use subforms placed on main form: disallowed editing will stop user to change data already inserted, but the user can add a new record.
If he wants to edit data he have to click on a button that allow...
The main form will stay opened when the user add a new product, so I think I will encounter the problem you said.
Default Access forms are ready to view records and add a new records, my problem is that editing records is "too much easy", but now I remember that there's an option to disallow...
Hi,
I'm building an Access application to manage various kind of products located somewhere.
I have a table for locations, and a table for every kind of product (because they have different attributes). Locations have an ID, and every product has that ID based on its location: that is how my...