How do I unlock a field on a form ONLY when adding a new record?

G

Guest

I have a form which has several fields locked (data that would not normally
change). But I want the fields to automatically be unlocked when adding a
new record. I have a macro which can lock/unlock the fields via a button on
the form, but I can't get the macro to kick off automatically on a new
record. I have tried assigning the macro to the "Befiore Insert" in the form
properties, but it doesn't seem to be running.

Any ideas?

Thanks.
 
G

Guest

To the OnCurrent event of the form you can write code that check if the
record is new and unlock the field

If Me.NewRecord Then
Me.FieldName.Locked = False
Else
Me.Fieldname.Locked = True
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Form/Subform Problems 3
lock main form unlock subform 7
Unlock a Field by fOSUserName() 4
Adding new record to a form 1
making a field editable once it has data. 4
Passing values from main form to a new record on a child form 4
Change Field Lock Property - subform on Tab Control 4

Top