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

Expand|Select|Wrap|Line Numbers

 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

Expand|Select|Wrap|Line Numbers

 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 :

Quote:

Originally Posted by sweetfalguni

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.

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

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

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

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

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

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about