I believe ADO uses single quotes Chr(39) instead of Chr(34). Give it a try.

>Does anyone see a major prob with the following: It doesn't like the commandtext line...
>
>

>Dim cn As New ADODB.Connection
>Dim cm As New ADODB.Command
>cn.Open "Driver=Microsoft Visual Foxpro Driver;UID=;SourceType=DBF;Deleted=YES;Null=NO;SourceDB=D:\"
>cm.ActiveConnection = cn
>cm.CommandType = adCmdUnknown
>cm.CommandText = "DELETE FROM C:\windows\system\Q12.dbf WHERE officeno = " & Chr(34) & cboOfficeNum.List(cboOfficeNum.ListIndex) & Chr(34)
>cm2.Execute
>

>My AdvaThanksnce