General information
Category:
Database DAO/RDO/ODBC/ADO
Hi ..
to use filter after select.., try this simple example below:
Dim rs as ADODB.RecordSet
rs.open "SELECT CUSTCODE, STOCKID, PRICE FROM SALES ORDER BY SALESDATE",cndata,adOpenKeyset, adLockReadOnly
Dim mCustCode as String
mCustCode = Text1.Text
rst.Filter = "CUSTCODE = '" & mCustCode & "'"
HTH
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only