Update field in table after update on a subform

[jpkeller55]

I am sure this is pretty straight forward but having some difficulty here. I am trying to update a field called "LastUpdated" in a table after a subform has been updated. I am using the following code:

DoCmd.RunSQL "UPDATE tblQuestions SET tblQuestions.LastUpdated = Now()
WHERE tblQuestions.QuestID = QuestID"

Instead of just upating the one record, I get a message asking me if I want to update all the records in the table (in this case 295). What am I doing wrong?

[pbaldy]

Because the value is inside the quotes, each record is being compared to itself. You want something like:

DoCmd.RunSQL "UPDATE tblQuestions SET tblQuestions.LastUpdated = Now() WHERE tblQuestions.QuestID = " & Me.QuestID

So the value comes from the form.

[jpkeller55]

Thanks Paul...that was it exactly. Works great. Take care.

[pbaldy]

Happy to help Jim.