How to lock users from modifying some records?

[Guest]

I have a master form that calls the detail form via push of a button (its not
a subform to the main form)

When I display records in the detail form, I would like users to be able to
modify only the last record and not allow them to make any changes to
previous records.

I am wondering how can this be done in Access database linked with Sql
server tables.

If its not possible to lock other records, then I would like to stop them
from modifying any records after create, how to do this?

Thank you in advance!
-Me

 

[Marshall Barton]

I have a master form that calls the detail form via push of a button (its not
a subform to the main form)

When I display records in the detail form, I would like users to be able to
modify only the last record and not allow them to make any changes to
previous records.

I am wondering how can this be done in Access database linked with Sql
server tables.

If its not possible to lock other records, then I would like to stop them
from modifying any records after create, how to do this?

In the detail form's Current event check which record you're
on:

With Me.RecordsetClone
,MoveLast
Me.AllowEdits = (Me.CurrentRecord = .RecordCount)
End With

 

[JethroUK©]

You can set the form properties:

allow editing = no

 

[Guest]

Hi Marsh,

Thank you, I will try your suggestion, I am sure it will work.
-Me

 

[Guest]

Thank you Jethro, I will try it out.
-Me

You can set the form properties:

allow editing = no