Allow additions but disable already entered data

[Chris Finke]

How can I disable some of the fields in an Access form so that they
are not accidentally edited, but still allow new records to be created
through the form? As of now, only the non-disabled fields can be
added.

 

[Allen Browne]

Use the Current event of the form, to set the Enabled properties of the
controls, based on whether it is a new record:

Private Sub Form_Current()
Dim bAllow As Boolean

bAllow = Me.NewRecord

Me.SomeField.Enabled = bAllow
Me.AnotherField.Enabled = bAllow
'etc.
End Sub

 

[Chris Finke]

in message


Use the Current event of the form, to set the Enabled properties of the
controls, based on whether it is a new record:

Private Sub Form_Current()
Dim bAllow As Boolean

bAllow = Me.NewRecord

Me.SomeField.Enabled = bAllow
Me.AnotherField.Enabled = bAllow
'etc.
End Sub

Thanks; this worked perfectly, although I chose to change it to

Me.SomeField.Locked = Not bAllow

so that the fields would not be grayed out, and thus, easier to read.

For anyone who reads this in the future for reference, I'm using
Access 2000 connecting to an MSSQL 2000 server.