SteveL13

<div>
<div class="content wysiwyg-content">
I want to lock a field on a form if the record is not a new record. &nbsp;I've tried this in the on current event but it doesn't work:<br />
<br />
&nbsp; &nbsp; If Me.NewRecord = True Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me.txtJobNumber.Locked = False<br />
&nbsp; &nbsp; Else<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me.txtJobNumber.Locked = True<br />
&nbsp; &nbsp; End If
</div>
</div>


I want to lock a field on a form if the record is not a new record.  I've tried this in the on current event but it doesn't work:

    If Me.NewRecord = True Then
        Me.txtJobNumber.Locked = False
    Else
        Me.txtJobNumber.Locked = True
    End If

Lock field on a form if the record is not a new record

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.