update SQL error

[the_dude via AccessMonster.com]

Dear all,

I am trying to update a field in a table from a text box on a subform.
Basically when the user opens the form they choose from different people and
get their details. i would like them to be able to update the data. So i have
created a button and on click the following SQL is executed:

CurrentDb.Execute "UPATE Sal_Core SET Molis_RequestStatus = '" &
Molis_RequestStatus & "' WHERE CaseRef = '" & CaseRef & "';"


The field in the Sal_Core table gets updated but I also get an error saying:

Microsoft jet database engine cannot find input tabel or query 'UPATE
Sal_Core SET Molis_RequestStatus = " WHERE CaseRef = ";' Make sure it exists
and that its name is spelled correctly.


Can anybody help? If the field in the table gets updated should mean that the
SQL syntax is correct but what is that error about?

Thank you very much in advance,

Olli

 

[John Spencer]

You have UPATE instead of UPDATE in your SQL statement as posted. I suspect
that the SQL is failing and what you are seeing in the field is the result
of the field being bound to a control in the form.

If the UPATE is a typo in your posting, then I don't have an idea of what
could be causing your problem.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..