This may belong in the Queries forum ... but my problem is I have an INSERT statement which is built from the entries the user has selected from the form. It works most of the time, but occasionally it won't run the INSERT properly, but doesn't generate an error message. I've set a breakpoint in the code to ensure the SQL string is being built correctly. When I close the form and open it again it works, or if I paste the INSERT string into a query and run that it works.
Does anyone know of some bug in Access which caused this to happen?
The code is:
DoCmd.RunSQL "insert into tblCrossRef(BookID,SubjectID) select " & nBookID & " as expr1, " & nSubjectID & " as expr2;"
Thanks.
Does anyone know of some bug in Access which caused this to happen?
The code is:
DoCmd.RunSQL "insert into tblCrossRef(BookID,SubjectID) select " & nBookID & " as expr1, " & nSubjectID & " as expr2;"
Thanks.