Can't update data in my Query

[drusteeby]

Slot Number is "Number" Serial number is "text"

 

[pbaldy]

Try

CurrentDb.Execute "UPDATE [VME Chassis Contents] SET [Slot Number] = " & Me.Combo44 & " WHERE [Serial Number] = '" & Me.CmboRepairHistory & "'"

 

[Atomic Shrimp]

This looks like it might be the same underlying cause as I encountered here:
http://www.access-programmers.co.uk/forums/showthread.php?t=175853

Your queries are different to mine, but the problem may be the same - that Jet doesn't know about your form objects, etc.


You could try evaluating the object references first, like this:
dim strSQL as string
strSQL = "UPDATE [VME Chassis Contents] SET [Slot Number] = " & Me.Combo44 & " WHERE [Serial Number] = " & Me.CmboRepairHistory
CurrentDb.Execute strSQL