Help on text boxes

[mdr0906]

Hello,

On a subform, I would like a text box to be filled in before the user saves the record and enters in a new one. Perhaps, have a message pop up when that particular box is not complete? Moreover, the box that I'm referring to is not the field that links to the main form.

Hopefully, my question makes sense. Thanks.

 

[missinglinq]

In the form the subform is based on:

Private Sub Form_BeforeUpdate(Cancel As Integer)
 If Len(Me.TargetTextBox & "") = 0 Then
   MsgBox "TargetTextBox Must Be Filled In!"
   Cancel = True
   TargetTextBox.SetFocus
  End If
End Sub