Access 2000 ADO CurrentProject Connection

[aktell]

Hi there,

Can anybody be of any HELP. I would like to figure out the following.

Insteat of using any wizards or else I would like to connect some text boxes "within" Access 2000 with VBA. I have two tables which I like to connect to and fill my text boxes.
There are some ideas I have but ................
My concern is what Sub Procedure do I take in VBA ??? etc.

I got the following from an MS Site.

Sub
'---
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset

Set cnn = CurrentProject.Connection
Set rst = New ADODB.Recordset

With rst
' Open table-type Recordset object.
.Open Source:=strTblName, _
      ActiveConnection:=cnn, _
      CursorType:=adOpenKeyset, _
      LockType:=adLockOptimistic, _
      Options:=adCmdTableDirect

'How do  I specify my tables and than of course my text boxes etc. ???

Set cnn = Nothing
End Sub

Thanks aktell