sql = "Select * From qry_defect" >> ??

[anggunpus]

I have source code in VBA
here is:

Private Sub Command1_Click()
Dim rs As Recordset
Dim sql As String
Dim qcatt As QCAttrib ' Create object variable.

sql = "Select * From tbl_defect" 'select from table
Set rs = CurrentDb.OpenRecordset(sql)
rs.OpenRecordset
Set qcatt = QCAttrib1.Object


qcatt.CCReset
............................


Why I can't change sql = "Select * From tbl_defect" select from query??
Can you help me?

[llkhoutx]

Your recordset is based upon the sql string. Modify the sql string or use the rs.FindFirst and rs.findNext commands to fins specific criteria. I presume that you're stepping though the recordset.

Query sql string are modified using the QueryName.sql property.

[anggunpus]

okay thank you!!