Null entries in subforms!

[sera]

Hello all!
I am having a problem. When a user enters data in a subform and then accidentally presses tab a null record is entered into my database. I want them to be able to add null data only if it is the only record that corresponds to the key! Sometimes it is important to have no data in the field! Does anyone know how to fix this problem?
Thanks,
Sera

 

[sera]

Does this post make no sense? Or is this just something that no one knows how to fix?
Sera

 

[Haitham]

Hi,

in your sub form you can write this code behined the control witch don't like to be Null,

Private Sub Thecontrol_Exit(Cancel As Integer)
If Not IsNull(Me.Thecontrol) Then
Else
MsgBox "Your Message to the user"
End If
End Sub

Hop Is Usefull

Good Luck