Locking of Entered Data

[Guest]

I have a Form with two Subforms. In one of the subforms, I want the client
to enter comments. It auto populates the date, time, and user name. Now the
next time this record is viewed, I want all the comments entered earlier to
be able to be viewed but not be changed. Ideas?

 

[Allen Browne]

Open the subform in design view, and set its AllowEdits property to No.

You probably want to set AllowDeletions to No as well.

Provided you leave AllowAdditions as Yes, the user can still add new
records.

 

[Guest]

If you want all the subform's controls to be uneditable apart from when
entering a new record then in its Current event procedure put:

Me.AllowEdits = Me.NewRecord

If its just the Comments control then put:

Me.Comments.Enabled = Me.NewRecord
Me.Comments.Locked = Not Me.NewRecord

Ken Sheridan
Stafford, England

 

[Guest]

Thank you Both!

If you want all the subform's controls to be uneditable apart from when
entering a new record then in its Current event procedure put:

Me.AllowEdits = Me.NewRecord

If its just the Comments control then put:

Me.Comments.Enabled = Me.NewRecord
Me.Comments.Locked = Not Me.NewRecord

Ken Sheridan
Stafford, England