Disable Field for single record

[Danny729]

Okay, so this database has a "status" drop down. I want fields to be enabled when the status is "Pending" but when the status is closed I want all the fields to be disabled.

My current code is:
If Me.Status.Value = "Closed" Then
Me.FieldName.Enabled = False

This, however, disables the fields across all records. I just want to disable the ability to alter a record once the record is closed.

[ranman256]

if you use a SINGLE record, then it only affects that 1 record.

if you are using a CONTINUOUS LIST form, it can only do it to ALL records.
but if you put the lock code in the form's ON CURRRENT, then moving the cursor to the next record, will unlock all fields if pending, or lock if closed.

Private Sub Form_Current()
  Me.FieldName.Enabled =Me.Status<> "Closed"
end sub