I've used this before:
Code:
Private Sub Form_Current()
If Me.NewRecord Then
Me.SubFormName.Locked = True
Else
Me.SubFormName.Locked = False
End If
End Sub
Private Sub MainControl1_AfterUpdate()
If IsNull(Me.MainControl1) Then
Me.SubFormName.Locked = True
Else
Me.SubFormName.Locked = False
End If
End Sub
Note that SubFormName is the name of the Subform Control...not the Form that resides there...which may or may not be the same!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007