The data control is used to connect to the database. Three properties are very necessary to connect to the database. The primary property is the database name. You can put this in the data control property. The syntax is as shown below:
Form.datacontrol.DatabaseName = pathname
The pathname is the position of the database file name. When the database is ex.mdb and the data control is Data1 next to put the DatabaseName property to do the initialization as shown below:
Data1.DatabaseName = "C:\ex.mdb"
The second property is the Connect property. The default is Access. When you click the drop down list box you'll examine that you can connect to the Paradox, Lotus, Dbase, Excel, and ODBC. You require setting the Connect property. The third property is a Record set property. It can be a dyna set type record set table, a table or a snap shot type record set. The Record Source can be a SQL statement or a table.