If statments

[Simon]

On my form i have a button that when it gets pressed it adds data to
the subform. the code works fine

I just want a if statment that will stop the code working if data
alredy existes in the subform.

If data exists i want a error message, if ther is no data let the code
run


Im not sure how to code it for it to see if there is data in the
subform


Any help will be great


Simon

 

[SJ]

oh, didn't realise that

If Not IsNull(Me.SUBFORMNAME.Form.PRIMARYKEYNAME) Then
Msgbox "Records exist.",vbinformation,"My Title"
exit sub
End If