Hi all, i'm trying to understand record locking and how to use it correctly within my new form. The designs a bit....strange managing customer accounts with a sub form that allows the user to put an order through as well. It seems to work really really well however on my submit button Access...