MS Access UPDATE not updating with cfquery

[adotfilm]

Three columns will update (GolaCalls, GoalContacts, and GoalAppts). However,
the two columns FirstName and LastName remain unchanged even if there is a
change to the field #form.FirstName# or #form.LastName#.
I get no error messages and if I hardcode #form.FirstName# to something like,
FROG, then it works. The variable is being passed as I have it print out for
verification.

Any ideas why FirstName and LastName will not update?

CODE:
<cfquery datasource="scorecarddb" username="####" password="####"
name="uploadrep">
UPDATE #tblName#
SET FirstName = '#form.FirstName#', LastName = '#form.LastName#', GoalCalls =
'#form.GoalCalls#', GoalContacts = '#form.GoalContacts#', GoalAppts =
'#form.GoalAppts#'
WHERE ((LastName = '#form.LastName#') AND (FirstName = '#form.FirstName#'));
</cfquery>

[Dan Bracuk]

Look at your where clause. You are saying change the names if they are equal the new values.

What is the primary key of your tblName table?

[adotfilm]

OK, good point. So I'm trying the WHERE clause with the primary key 'ID',
having this field passed into the query from a hidden field--BUT--it still
isn't working.

UPDATE #tblName#
SET FirstName = '#form.FirstName#', LastName = '#form.LastName#', GoalCalls =
'#form.GoalCalls#', GoalContacts = '#form.GoalContacts#', GoalAppts =
'#form.GoalAppts#'
WHERE ID = '#form.ID#';

[Dan Bracuk]

Take the quotes away from any numeric fields. ID is probably one of them.

[adotfilm]

Thank you for your help. I created another column to use as an unique numeric ID for each person and referenced that. Couldn't make the Primary Key work for some reason. Thanks again.