• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1100
  • Last Modified:

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
0
Genius123
Asked:
Genius123
1 Solution
 
Eric ShermanAccountant/DeveloperCommented:
If this is a continuous form, probably not.  You could change the Recordset to Snapshot but that would apply to all records.

If you are using a single record display then you could try something like test for the max record id and if it's the last one then lock all fields on your form.

Just an idea.

ET
0
 
Jeffrey CoachmanMIS LiasonCommented:
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...
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now