VBA Help, Using Variables in an SQL Update Statement

[Critchley]

--- Accidental Duplicate Thread, Please Delete ---

Hi all,

Im using this code to try and update collumns in a table in Access 2003.

I cant seem to get the code to work with the variables, Lookup asks to define a parameter even though it is set to the inputbox string, and test causes a type conversion error even though the table is set to Date/time.

I am very new to VBA And this is my first project.

I put the msgboxs in to check that the variables were set to the correct values before the UPDATE command, which they are.

'Update Button
Private Sub Toggle28_Click()

Dim Lookup As String
Dim test As Date

test = DateValue("Jan 01 2015")

Dim Update_QCourseData As String

Lookup = InputBox("Enter your service number", Update, " ")

MsgBox (test)
MsgBox (Lookup)


DoCmd.RunSQL ("UPDATE QCourseData " & _
"SET [Date Completed] = 'test'" & _
"WHERE [Service Number] = Lookup")



End Sub

[Kyle123]

Hello, welcome to the forum

When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.

(link above in the menu bar)

Unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Also, when posting code, please use code tags

[Critchley]

Sorry about that, I didnt notice. Was having problems with my browser as im at work right now and didnt think it posted first time!

Dont think i can close this thread myself, else i would.

[Fotis1991]

So thread closed.