ADO Data Control Error,

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????

AnyONE PLEASE???????????

first check whether the adodc control u have used supports the functionality using the following code :

if adoguest.recordset.supports(adAddNew) then
msgbox "Supported"
else
msgbox "Not supported"
end if

write this code in the addnew command button u r using

this is so because many recorset does not support this feature!

what error do u get
can u be bit clear:confused:

You didn't specify your error. If you're having problems refreshing, you can also try the requery method.



:)