Field allow create but not update

[techexpressinc]

Is there a easy way to do this?



I tried Lock but then the users can not add a record. I want them to be able to add but then lock them out of updating a field.

Thx
Russ

[weekend00]

set property allow edit to false, allow delete to false and allow add to true.

[techexpressinc]

Where are these properties - on the field's property "Event " tab or " Data" tab or??
Thx
Russ

[weekend00]

form's property.

right click on blank area(black area) of the form, you will get it.

[techexpressinc]

I only did to lock out one field the plan-id the rest the users need to update regularly.

Russ

[weekend00]

All right, go to you first post.

set lock=true for that field, when new record added(after insert event?), unlock it, when focus move to old record(after update event), lock it again.

I am not sure which event is the right one. you may try.

[weekend00]

I've tried following code:
(textbox name for the field is "A")

Private Sub A_GotFocus()
          If NewRecord Then A.Locked = False Else A.Locked = True
End Sub
Private Sub A_LostFocus()
       If NewRecord Then A.Locked = False Else A.Locked = True
End Sub

[techexpressinc]

I thinking it would be multiple places?

Before Update..
On Change ...
On Update...
On Exit..
On Click...


Does that sound right?

Thx
Rus

[weekend00]

As my example, only lost_focus and get_focus events