SQL NoMatch

[paul]

i have a SQL statment that will not always return a record. What I want is this: When there is no match for sql statment Then Add
Item to database along with mor information . any help would be appreciated.

------------------

[DVint]

You've already described the function to use: after executing a recordset Seek or FindFirst, you provide code for what to do if the record is not found this way:
If Recordset.NoMatch Then
'do stuff
End If
Dave

------------------