Insert-command doesn't work

[fluidmind]

Hi there!

I'm quite new to this SQL-stuff, and I'm having some troubles with an onclick-command, that I was hoping you could help me with... I know that it is a very simple question to you SQL-guru's, but what the hell...

In my form I have three text-boxes (I1, II1 and III1) and in my table called 'sælgerdata' i have a yes/no column called "kursus1" and my keystring is called "sælgernr" (which means employee-number).

In the textboxes i list three employees, and when the button is pressed I want all the employees whose numbers are entered to have the value "-1" added to their "kursus1" column.

When I press the button I get no error, but no data is added to the

Here is my code. What is wrong??? I really hope you can help me...

//JR

-------------------------------------------------
Private Sub Kommandoknap16_Click()

If I1 <> "" Then
strSQL = "INSERT INTO sælgerdata.kursus1 " & _
"VALUES ('-1');" & _
"WHERE sælgernr = " & Me!I1
End If

If II1 <> "" Then
strSQL = "INSERT INTO sælgerdata.kursus1 " & _
"VALUES ('-1');" & _
"WHERE sælgernr = " & Me!II1
End If

If III1 <> "" Then
strSQL = "INSERT INTO sælgerdata.kursus1 " & _
"VALUES ('-1');" & _
"WHERE sælgernr = " & Me!III1
End If

End Sub
-------------------------------------------------------

 

[fluidmind]

That was stupid

Please dont answer this one... Plenty of bad stuff in there...

I figured it out!

- Update (not insert)
- RunSQL (allways a good idea)
- And on and on and on...

Sorry