Error in insert syntax

[h3llz]

qryString = "INSERT INTO tblProductsLog
(staffID,productID,quantity,timestamp) VALUES ('" & staffID & "','" &
txtProductID.Caption & "','-" & cmoSelectQuantity.Text & "','" & Now() & "');"

whats wrong?

 

[Stuart McCall]

qryString = "INSERT INTO tblProductsLog
(staffID,productID,quantity,timestamp) VALUES ('" & staffID & "','" &
txtProductID.Caption & "','-" & cmoSelectQuantity.Text & "','" & Now() &
"');"

whats wrong?

Lose the quotes surrounding the Now() function.

 

[h3llz]

How do i execute the qryString?
Mydb.OpenRecordset (qryString)
is wrong i assume

 

[Stuart McCall]

How do i execute the qryString?
Mydb.OpenRecordset (qryString)
is wrong i assume

Either:

CurrentDb.Execute qryString, dbFailOnError

which will run without prompting the user, plus errors can be trapped.

or:

DoCmd.RunSQL qryString

which will (by default) ask user to confirm the action.