This is lengthy, but I really need help on this one.
I am writing a VB program to access a Microsoft Access Database. I would like to be able to open up different files and have this information show up on my forms in VB.
I have made up an Access database with nine tables in it.
The database is made up to store values for factors that affect peoples concern for the environment. My idea is to store information for different years (ex. 1997, 2000) in different files.
I have made up forms in Visual Basic for each of these tables to show the information stored in the fields.
My start up form has a DriveListBox, DirectoryListBox, a FileListBox and a control to open a file.
What I would like to do is when a file is selected, have Visual Basic connect to the Access database and go to another form in which the user will select which table they want to view information from.
The next form will then come up on the screen with the information from that particular table of the database displayed in the textboxes.
Hopefully this makes sence without actually seeing how I have everything set up. Is it possible to do this, if so, how? Any help is appreciated.

Miasri