Very Computer

I am new to Visual Basic and I am writing a small Database program to
become more familiar with it.  But I have run into a problem.  My
problem is that I have a File Open menu option which lets you choose the
Database you want to open, but I can't figure out how to set the
RecordSource at run time.  I have figured out how to set the Database
name:
            Data1.DatabaseName = CommonDialog1.filename
But I can't figure out how to show the underlying table for that
Database, so that I can set it equal to the RecordSource.  I can set it
in the Properties, but I want to be able to do it at run time.  I'm not
even sure if I am doing this right, but any help would be greatly
appreciated.
        Thanks,
                Marc

Quote:>I am new to Visual Basic and I am writing a small Database program to become

I use bound Data Controls and change the RecordSource Property by:
Data1.RecordSource = sSQL
                        Data1.Refresh
where sSQL is a SQL Query in double quotes.  Maybe all you
need to do is to put the table name in double quotes instead.

Quote:>I am new to Visual Basic and I am writing a small Database program to
>become more familiar with it.  But I have run into a problem.  My
>problem is that I have a File Open menu option which lets you choose the
>Database you want to open, but I can't figure out how to set the
>RecordSource at run time.  I have figured out how to set the Database
>name:
>            Data1.DatabaseName = CommonDialog1.filename
>But I can't figure out how to show the underlying table for that
>Database, so that I can set it equal to the RecordSource.  I can set it
>in the Properties, but I want to be able to do it at run time.  I'm not
>even sure if I am doing this right, but any help would be greatly
>appreciated.
>        Thanks,
>                Marc