How to lock a field in a record or make it read only in Access 2007

[sweetfalguni]

Hello,

The codes below worked successfully in Access 2003

Private Sub Form_Current()
  If Me.NewRecord Then
    Me.AllowAdditions = True
    Me.AllowDeletions = True
    Me.AllowEdits = True
Else
    Me.AllowAdditions = True
    Me.AllowDeletions = False
    Me.AllowEdits = False
End If

and

Sub cmdEdit_Click 
On Error GoTo Err_cmdEdit_Click 
  
   Me.AllowEdits = True 
  
Exit_cmdEdit_Click: 
    Exit Sub 
  
Err_cmdEdit_Click: 
    MsgBox Err.Description 
    Resume Exit_cmdEdit_Click 
  
End sub

It works successfully in Access 2003 but it doesnt work in Access 2007. Please help

[ChipR]

I think I remember having a problem with this. I ended up locking/disabling each of the relevant controls.

[NeoPa]

Can you please expand on :

It works successfully in Access 2003 but it doesnt work in Access 2007.

Does it give an error message?
If so what?
Which line does it fail on?

[Megalog]

If this has been converted to a Split Form after your 2007 upgrade, it may not work.
You'll have to replace the "Me." with "[Forms]![formname]."

If not, then... I'm not sure =)

[ChipR]

In my experience, there was no error message. AllowEdits = False just seems to have no effect.