Lock data-entry

[giovi2002]

When a order (identified by orderid) of products reaches a certain status I lock the article numbers (with an orderrule number 1 to many to that order-id) from changing. This works ok, the user can't change the article numbers and quantities. What doesn't work is the fact that they can still add records to that order. How can I get Access that far that they can't add records?

 

[RichO]

How about setting the Allow Additions property to No via VBA code?

 

[still_rookie]

how about changing Record Locks from form properties to 'All records' and set the following to No from the same properties window :

'Allow edits'
'Allow additions'

did that help lol ?

 

[giovi2002]

Thanks guys i will give it a try