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