Hi All,
In my afterupdate I have a code to update and append data from one table to another if data exists. I simply have an Insert Into sql in my code and then fire it off with db.execute strSQL, dbFailOnError where db is Dim db DAO.Database, Set db=CurrentDB.
This works fine if there's something to update and append but if there's nothing in the table I get an error that there are too few parameters. I know that sql is good because it works otherwise, how can I get it to stop if data isn't found that matches the criteria?