Link to home
Create AccountLog in
Avatar of Genius123
Genius123Flag for United States of America

asked on

MS Access 2010 lock record in form

Hello,

I have an Access form where I want to lock the last record to keep people from editing it, but the other records are ok to edit.  Is that possible?

Thanks, Joel
ASKER CERTIFIED SOLUTION
Avatar of Eric Sherman
Eric Sherman
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Remember that a table really does not have a "last" record.
A table can be sorted in any order, so the "last" record can change.

If you mean the most "recent" record, then you can add a "created date" field to your table and add in the current date time.
The sort a query of this table by this date field, ...then do as etsherman suggests above...