Hi, i am using VB6 with Access databse after a long time and have forgotten some syntax.
I am using ADODC connection (the dirty method) wherein one makes a connection using ADODC component and setting its properties (ODBC and selecting table/ query).
I need to display the fields of a recordset in the form where the field value is given in the text1.text.
I remember vaugely that we used expressions like
Dim str as String
str =" SELECT * FROM paybook WHERE paybook.Field(0) = '"&text1.text&"'"
thereafter how to use this i am ot remembering
Need your help on this please