How to find record in table with ID=1 and update its value.

[kassem]

hi all,


I want to find the record in the table Out_Inst_Val and set a field called Out_Inst_Val to the value in text144 for the record with ID=1.
i tried the following code but am not sure whats wrong.

CurrentDb.Execute "UPDATE Out_Inst_Val SET [Out_Inst_Val] = text144 WHERE [ID] = 1"

thanks.

[ItsMe]

What is text144? The name of a control? What is the data type, text?

CurrentDb.Execute "UPDATE Out_Inst_Val SET [Out_Inst_Val] = '" & Me.text144 & "' WHERE [ID] = 1"

[kassem]

Hi ItsMe,

Text144 is a textbox which hold a string

the code is mostly right except the part where u wrote '" & Me.text144 & "'.

i made it

CurrentDb.Execute "UPDATE Out_Inst_Val SET [Out_Inst_Val] = 3 WHERE [ID] = 1"

for a test and it works. I basically want the Out_Inst_Val to be equal to the value in text144 (in this case 3).
thanks.

[ItsMe]

3 looks like a Number type. I wrote the code for a Text type.

Try
CurrentDb.Execute "UPDATE Out_Inst_Val SET [Out_Inst_Val] = " & Me.text144 & " WHERE [ID] = 1"

[Missinglinq]

If this is true

i made it

CurrentDb.Execute "UPDATE Out_Inst_Val SET [Out_Inst_Val] = 3 WHERE [ID] = 1"

for a test and it works. I basically want the Out_Inst_Val to be equal to the value in text144 (in this case 3).

then the line

Text144 is a textbox which hold a string

is obviously wrong, which is why

'" & Me.text144 & "'

wasn't correct! You have to give correct info when posting questions in order to get correct solutions!

Linq ;0)>