> 'Create the SQL command. > strSQLCommand = "INSERT INTO " + strDBTable + " VALUES (null" + > strUpdate + ");"
http://www.sqlite.org/lang_corefunc.html Use last_insert_rowid() as a second statement in your query: 'Create the SQL command. strSQLCommand = "INSERT INTO " + strDBTable + " VALUES (null" + strUpdate + ");" strSQLCommand = strSQLCommand + "select last_insert_rowid();" 'DATABASE: Execute the query. bSuccess = Me.DBConnection.Execute(strSQLCommand) Though, you'll need to examine the resulting recordset, rather than check for a boolean value. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users