Data DatabaseName and RecordSource

[JureVI]

Hi

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

This database (base.mdb) has 18 records, but data1.database.recordsets("Table").RecordCount returns only 1 record if I load it in Data1. How can I load a database in Data control and set the Recordset in code, when application starts (Form_Load())? Thanks.

Jure

[Deepfreeze]

This sounds almost exactly like what I wanted to do, and a code example is posted in the thread I started called "How to hardcode an Adodc?" Take a look and see if that helps. It worked for me.

Deepfreeze