Hi all, is it possible to create an action query that locks records? I have a subform that users will need to update, but I don't want them to be able to edit 'already processed' information.
Ideally what I'd like to do, is have a control button that brings up a dialogue box requesting what (invoice) number you wish to lock, then having it lock all records with that invoice number in the table behind the subform, so that they can still be viewed on the form, but can't be edited. I thought an action query might be the easiest way to do this.
I'm an Access newb and have very little clue about VBA or anything like that, if anyone could help that would be much appreciated.
Ideally what I'd like to do, is have a control button that brings up a dialogue box requesting what (invoice) number you wish to lock, then having it lock all records with that invoice number in the table behind the subform, so that they can still be viewed on the form, but can't be edited. I thought an action query might be the easiest way to do this.
I'm an Access newb and have very little clue about VBA or anything like that, if anyone could help that would be much appreciated.