DBGrid

[mecca]

I build a SELECT query. Now I want to populate my dbgrid based on the query results. How do I do this?

[mecca]

Thanks. My goal was to figure it out w/o usinig data control. So I used MSFlexGrid and populated the grid w/o using the data control. Works great.

[Clunietp]

Add a DB grid and data control to your form. Set the DATASOURCE property of the grid to the data control. Add this code where you want it:


Dim db As Database

Set db = DBEngine.OpenDatabase("Nwind.mdb")

Set Data1.Recordset = db.OpenRecordset("Select * from Customers")

db.close
set db = nothing



All done

Tom