View Full Version : Locking a single record


ankrumc
11-30-2010, 07:11 AM
Is it possible to lock a single record so that it is used as a template?

I have almost 500 records, and I just want to lock the 1st one so that when it pops up, the text isn't editable, but when another record is pulled up, the new record is editable.

Thanks!

vbaInet
11-30-2010, 07:55 AM
Is this for a continuous form? Of course I'm assuming you're using a form for this.

ankrumc
11-30-2010, 08:22 AM
Yes, it is. Thoughts?

vbaInet
11-30-2010, 10:28 AM
Ok, here's what you put in the Current event of your form:

Me.AllowEdits = (Me.CurrentRecord <> 1)