Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
displaying filtered data in a grid
- Thread starter FBM357
- Start date
Select in your recordset, then set the grid's datasource to your recordset:
strSQL = "Select * from myTable Wher EmpID = " & txtEmpID
Set rst = cn.Execute(strSQL)
Grid1.Datasource = rst
assuming you have a valid ADO connection called cn
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
strSQL = "Select * from myTable Wher EmpID = " & txtEmpID
Set rst = cn.Execute(strSQL)
Grid1.Datasource = rst
assuming you have a valid ADO connection called cn
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
- Thread starter
- #3
- Status
