Hi

I have a form that has a number of rows and i would like users to be able to edit some rows but not other. the non edit rows will have an entry in a field that the other won't.

Is it possible to have diffrent edit right in the same form but for diffrent rows?

If you're saying that if a given Control has data in it then that Record will not allow editing, then, replacing TargetField with the actual name of the Textbox that holds the Field that this will be based on:

Code:

Private Sub Form_Current()
 If Nz(Me.TargetField, "") <> "" Then
  Me.AllowEdits = False
 Else
  Me.AllowEdits = True
 End If
End Sub

If this is not the situation, you need to explain your need a little more clearly.

Linq ;0)>