Hi everyone,

I've been using DataGrid for a while, but I had been using with ADO, so now I need to use the old DAO (because ADO doesn't support crosstab queries) but the thing is that TDBGrid doesn't show me any data of the DAO Recordset and it appears a error message: "Type mistmatch", my code is something like this:

Dim db_current As Database
Dim db_qd As QueryDef
Dim db_rs As Recordset

Set db_current = OpenDatabase("c:\example_db.mdb")

Set db_qd = db_current.CreateQueryDef("")
With db_qd
.SQL = "SELECT * FROM table_example"
Set db_rs = .OpenRecordset()
End With

Set dataGrid1.DataSource = db_rs
' Call dataGrid1.Refresh

What is missing? or what am I doing wrong?