Hi,
I am gertting an error when using the Refresh Method of the ADODC.

I am unable to find any help on ADODC (I do not have MSDN).

The code is here :


If imgSeat(Index).Picture <> imgSmile.Picture Then
frmGuest.adoGuest.Recordset.AddNew
'imgSeat(Index).Picture = imgSmile.Picture
frmGuest.lblSeatNum.Caption = Index + 1
'frmGuest.lblTable.Caption =
If (Index >= 0 And Index <= 9) Then
frmGuest.lblTable.Caption = 1
ElseIf (Index >= 10 And Index <= 19) Then
frmGuest.lblTable.Caption = 2
ElseIf (Index >= 20 And Index <= 29) Then
frmGuest.lblTable.Caption = 3
ElseIf (Index >= 30 And Index <= 39) Then
frmGuest.lblTable.Caption = 4
End If

frmGuest.cmdDelete.Enabled = False
Else
frmGuest.adoGuest.RecordSource = "select * from tblGuest
where fldSeat = " & Index + 1
frmGuest.adoGuest.Refresh
frmGuest.cmdDelete.Enabled = True
End If


Cna anyone help me please????