Listbox Database

[k0r54]

Hi
Firstly I have a listbox and I want the user to select an item from the list box and then click cmdStartStop

when cmdStartStop is pressed i want it to put "Not Running" into the field Live WHERE the Campaign_Name is = to the lstnotrunning.text

I am trying to put the variable Not Running Select into the **Insert NotRunningSelect** but it doesn't alow me to

Dim NotRunningSelect As String
NotRunningSelect = lstNotRunning.Text
If cmdStartStop.Caption = "Stop Campaign" Then
NotRunning.Source "Select * From T_Campaigns WHERE Campaign_Name = **Insert NotRunningSelect** "
NotRunning.Open , db, adOpenKeyset, adLockOptimistic
NotRunning.Fields(Live).Value = "Not Running"

Any idea on what im doin wrong or a better way to do it

tnx adz