Set the DBGrid's DataSource property to the Data control.

[nandagopal]

Place a DBGrid and Data control on the form. Set the DBGrid's DataSource property to the Data control. Set other properties such as AllowAddNew, AllowDelete, and AllowUpdate as desired.

Set the Data control's DatabaseName property to the database. This example sets the database name at runtime like this:


Private Sub Form_Load()
    Data1.DatabaseName = App.Path & "\CoData.mdb"
End Sub


Set the Data control's RecordSource property to the SQL SELECT statement the control should use to pick the data to be displayed. In this example, the property is set to:

    SELECT Name, Department, Manager
    FROM Employees, Departments
    WHERE Employees.Department =  Departments.DepartmentName

The DBGrid control displays the data automatically.