I have all my fields populted.

On to the next part.

How do I move around from record to record?

This is what I have so far for the record connection.





Private cn As ADODB.Connection
Private rs As ADODB.Recordset

Private Sub Form_Load()
Set cn = New ADODB.Connection
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Documents and Settings\Administrator\Desktop\STG\STGDB.mdb"
cn.Open
Set rs = New ADODB.Recordset
rs.Open "T_all", cn, adOpenKeyset, adLockPessimistic, adCmdTable
Set cn = Nothing
Call fillfields ' sub below

End Sub