Hi

I have created to tables, Invoice and Customer, within a database named Elegant.

I have also designed to forms pertaining to each of these tables.

In each form I use the Data control within VB5 to link the form to the database, and I code the following in each forms load event:

Data1.DatabaseName= app.path & "\elegant.mdb"

I am also designing a user control which will be used to move though the tables, Next, Previous, Top, Bottom, Add, Remove, Edit, etc.

I would like to code this user control as generically as possible so that I may drop it in any similar form in any application and that it can perform the events regerdless of the database and table in use.
How can I access the database in use at run-time so I can replace the following type statements within my user control:

Elegant.Recordset.MoveNext