How to make update a field of a table

[David Bowen]

I am trying to update the field [dummylink] which is in the table [tblGeneral Contract Information]with strInputtext (this variable is a string)

When it runs it does not seem to do anything at all.


CurrentDb.Execute "UPDATE [tblGeneral Contract Information] SET [dummylink] = '" & strInputtext & "'" & "WHERE [tblGeneral Contract Information]![V File Number] = " & "'Me.[V File Number]'", dbFailOnError


Could you please help.

 

[Marshall Barton]

I am trying to update the field [dummylink] which is in the table [tblGeneral Contract Information]with strInputtext (this variable is a string)

When it runs it does not seem to do anything at all.


CurrentDb.Execute "UPDATE [tblGeneral Contract Information] SET [dummylink] = '" & strInputtext & "'" & "WHERE [tblGeneral Contract Information]![V File Number] = " & "'Me.[V File Number]'", dbFailOnError

The quotes for the second value are not right:

"UPDATE [tblGeneral Contract Information] SET [dummylink] =
'" & strInputtext & "' WHERE [tblGeneral Contract
Information]![V File Number] = '" & Me.[V File Number] & "'
", dbFailOnError

 

[David Bowen]

If you mean this = '" & Me.[V File Number] & "'

That is good to know. The problem is that if I remove this I get a "data miss match" error.

 

[Marshall Barton]

If you mean this = '" & Me.[V File Number] & "'

That is good to know. The problem is that if I
remove this I get a "data miss match" error.

Line wrap might have obscured what I said.
Trying again to get it all on one line:
. . . = '" & Me.[V File Number] & "' ", . . .

However, that error implies that [V File Number] is a
numeric type field in its table. If that's the case, then
it should be:
. . . = " & Me.[V File Number], . . .