I don't know if this will help you with your problem, but the following is how I link my form to an access database;
You need a connection to the database and a recordset, for the purpose of this example i will call the connection "tom", the recordset "bob", the database "bill", and the table in the database "sam"
dim Tom as connection
dim Bob as recordset
' connection to database
Set Tom = New Connection
Tom.ConnectionString = "provider=microsoft.jet.oledb.4.0; data _ source=c:\database\Bill.mdb"
Tom.Open
' Recordset to a table in the database
Set Bob = New Recordset
Bob.CursorType = adOpenStatic
Bob.Open "Sam", Tom, , , adCmdTable
' then you link a field in the database to a variable in the table as follows
' "name" is a field in the database and "txtTest" is a textbox in the database
txtTest.text = Bob!name
That is it, make a connection to each of the fields you want to use in the table in the database and you hve your connection. saving and updating is a whole new problem