I am trying to fill a list box with data from different tables inside the dame Access database. Would I have to query the data together by the same sample number or what and if I do have to where is a good place to learn the basics of it.

Thanks!

Well now I am getting a Compile error: User-defined type not defined. When I was not before?
Its throwing the error at Dim db As Database.

Code:

Dim ws As Workspace
Dim db As Database

Set ws = DBEngine.Worksp ace(0)
Set db = ws.OpenDatabase ("c:\Users\BC\D esktop\Geog485\ master_sample_d atabase\B518feb 2009.mdb")

I want to access a MS Access database where I can pull information from and display it. The trouble is, I cannot get my code to access it. When I look at my code it just doesn't seem right, too.

where is what I have for access the database:

Dim ws As Workspace
Dim db As Database

Set ws = DBEngine.Worksp ace(0)
Set db = ws.OpenDatabase ("c:\Users\Desk top\folder \master_sample_ database\B518fe b2009")...