Locking a single record

[ankrumc]

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]

Is this for a continuous form? Of course I'm assuming you're using a form for this.

 

[ankrumc]

Yes, it is. Thoughts?

 

[vbaInet]

Ok, here's what you put in the Current event of your form:

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