Hi, i am using variables in database but both times they dont work.

First example is, problem is there is no error message apart from sayin that its not there, so i knwo the syntax is A valid one but whether its right ?????

VB Code:
  1. If cmdStartStop.Caption = "Stop Campaign" Then

  2. NotRunning.Source = "Select * From T_Campaigns WHERE Campaign_Name = ' " & lstNotRunning.Text & " ' ;"

  3. NotRunning.Open , db, adOpenKeyset, adLockOptimistic

  4. With NotRunning

  5. .Fields("Live").Value = "Not Running"

  6. .Update

  7. NotRunning.Close

  8. Call ListLoad

  9. End With

  10. End If

and the second is on a different form but same thing, dont pick it up

VB Code:
  1. If db Is Nothing Then OpenConnectionCampaign

  2.   Set CallBack = New ADODB.Recordset

  3.   CallBack.Open "SHAPE {SELECT & 'CallBackList' & FROM Data WHERE CallBack = 'True' } AS ParentCMD2 APPEND ({SELECT '& CallBackList &' FROM Data WHERE CallBack = 'True'} AS ChildCMD2 RELATE Telephone_Number TO Telephone_Number) AS ChildCMD2", db, adOpenStatic, adLockOptimistic

  4.   bCancelResult = False

  5.   Set grdDataGrid.DataSource = CallBack.DataSource

any idea's

tnx