Subform fields 1

[3063]

I have a subform that I am trying to set it up where the data that has been keyed cannot be edited or changed, but will also will allow additional data. I have looked in the properties and seen were you can lock fields down, but I need to be able to add additional data to it.

 

[jdgreen]

Are you saying that once a field is updated you don't want anyone to be able to change it? If so you could accomplish this using the locked property of the field either on the form open event and if you want it to lock immediately after the information is entered on the after update event of the field.

John Green

 

[TheAceMan1]

How are ya 3063 . . . . .

In the On Current event of the subForm, try this:

[blue]   If Me.NewRecord Then
      Me!AllowEdits = True
   Else
      Me!AllowEdits = False
   End If[/blue]

See Ya! . . . . . .