i have only recently looked into vb6 for database manipulation and i have used the code : -
-------------------
Data2.Recordset.MoveFirst
Dim criterion1 As String
criterion1 = "DSTRCT_CODE = " & Chr$(39) & Data1.Recordset!DSTRCT_CODE & Chr$(39)
Data2.Recordset.FindFirst criterion1
-------------------
to find specific records.

how to i set this sort of staement up to allow a second criterion ie stock code so it finds the first record in data2 with a matching district code & stock code??