Update query problem

[pratim09]

I have a form with prepopulated value with few fields which opens up on click of a particular record in previous form.One of the fields in the current form is Trackingid whose text field is disabled which will come from previous form and that is the primary key of the table and it is a autonumber datatype . Now I want to modify a field release name in the current form for that particular tracking id .Below is the update query

strSQL = "UPDATE HoursTracking SET [Release Name] = '" & txtReleaseName & "' WHERE TrackingId = '" & txtReleaseName & "'"

DoCmd.RunSQL strSQL



I am getting the below error

Datatype mismatch in criteria expression.

I have TrackingId and txtReleaseName as String and in database Tracking Id column is autonumber and Release Name column is Text


Plz help ..I am stuck on this for 2 hours now.

[jzwp11]

Is the release name in the original form? You can bring that into the second form that opens as well. Is the second form bound or unbound? I assume that the second form is unbound and hence why you need the update query. Do you have a button on the form that executes the update query?

Why don't you have the trackingID control referenced in the WHERE clause of the update query? This is what you currently have:

strSQL = "UPDATE HoursTracking SET [Release Name] = '" & txtReleaseName & "' WHERE TrackingId = '" & txtReleaseName & "'"

Shouldn't it be this:

strSQL = "UPDATE HoursTracking SET [Release Name] = '" & me.txtReleaseName & "' WHERE TrackingId = " & me.trackingID

I've added the me. shortcuts to refer to the current form

[pratim09]

Soory the update statement i gave was little wrong the actual one is

strSQL = "UPDATE HoursTracking SET [Release Name] = '" & txtReleaseName & "' WHERE TrackingId = '" & Me.TrackingId & "'"

and still its not working .

I have the release name in the current form and if I print the strSQL through msgbox i am getting the below

UPDATE HoursTracking SET [Release Name] = '2010MR-NOV' WHERE TrackingId = '9792'

I am using the code in the click eventy of a modify button in the form

[jzwp11]

You said that the trackingID field (in the table) is autonumber, as such, the trackingID value must not be enclosed in the single quotes as you showed:

UPDATE HoursTracking SET [Release Name] = '2010MR-NOV' WHERE TrackingId = '9792'

[pratim09]

Thanks a lot ....

[jzwp11]

You're welcome.