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:
All doneCode:Dim db As Database Set db = DBEngine.OpenDatabase("Nwind.mdb") Set Data1.Recordset = db.OpenRecordset("Select * from Customers") db.close set db = nothing
Tom




Reply With Quote