SQL String Value

[IanT]

I have a sql statement to update a table, the sql string is called strSQl as below:
strSQL = "INSERT INTO tblQuote etc etc"

Is it possibel to identify if there is a value returned, as if there isn't I would like to record the fact in the table!

 

[RoyVidar]

I'm not sure i understand your question, an insert query doesn't "return a value", but if it relates to number of records inserted, you could try:

dim db as dao.database
set db=currentdb
db.execute strsql
msgbox db.recordsaffected