Beetle - thanks for quick reply.
This solution works, but it's not ideal - here's why.
The very first field on my form is a Parcel ID number which is required.
Once that number is entered the first time, I would like it to be locked.
Here's the catch: there are a number of other fields on the form that, in
practice will be populated over the course of time. Some may be filled in
right away, when the Parcel ID number is first entered, some may be filled in
weeks later, and some may need to be edited several years later. The forms
current event affects all of these controls and I would like it to only
affect the first one (Parcel ID).
- mjg
> In the forms current event
>
[quoted text clipped - 15 lines]
> >
> > -mjg
Douglas J. Steele - 18 Mar 2008 20:54 GMT
But Beetle's suggestion is strictly locking a single control!
Based on what you've added, you'd probably want
If Me.NewRecord Then
Me.ParcelID.Locked = False
Else
If Len(Me.ParcelID & vbNullString) > 0 Then
Me.ParcelID.Locked = True
Else
Me.ParcelID.Locked = False
End If
End If
Even simpler is
Me.ParcelID.Locked = Not Me.NewRecord And (Len(Me.ParcelID & vbNullString) >
0)
Note that you'll likely want to introduce some means of unlocking the field
in case an error needs to be corrected.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> Beetle - thanks for quick reply.
>
[quoted text clipped - 33 lines]
>> >
>> > -mjg
mjg - 19 Mar 2008 15:17 GMT
You were right, Beetle's solution worked fine.
I'm new to VB and don't understand some of the code below
("Len...vbNullString") so I just stuck with the simple solution.
Thanks for your help,
-mjg
> But Beetle's suggestion is strictly locking a single control!
>
[quoted text clipped - 55 lines]
> >> >
> >> > -mjg