Finding a records (ADO)

I have a table with a primarykey (four fields) how can i build a criteria to find or seek a record in the recordset?


TIA

use:
DBFCentro.Recordset.FindFirst ("Cod_Centro = " & Val(DBFParam.Recordset.Fields("Param4")))
or a SQL.
data1.recordsource = "SELECT * FROM Tabla1 WHERE Variable1 = 1;"

I am sorry I dont understand, please explain further.


the primarykey have 4 fields (fielda,fieldb,fieldc,fieldd)

Thanks,

:( :(

Waht is wrong??? error 3001


cCriterio = "Cod_Ciudad = '" & DEMkt.rsVTA005006!FCOST & "'"

cCriterio = cCriterio & " And " & "Cod_Vende = '" & DEMkt.rsVTA005006!FNRVEN & "'"

cCriterio = cCriterio & " And " & "Cod_Cliente = '" & DEMkt.rsVTA005006!FNRCLI & "'"

cCriterio = cCriterio & " And " & "Cod_Articulo = '" & DEMkt.rsVTA005006!F1ARTI & "'"

cCriterio = cCriterio & " And " & "Tipo_Articulo = '" & DEMkt.rsVTA005006!F1TIPR & "'"


DEMkt.rsVENTASMKT.Find (cCriterio)



TIA