I believe (if I understand your question correctly), that the best way to navigate through a recordset is not by using a data control, but by setting all of your connections in code. For example:
Private Sub Form_Load()
dim con as adodb.connection 'declares database connection
set con = new adodb.connection
dim rs as adodb.recordset 'declares recordset
set rs = new adodb.connection
with con
.ConnectionString = app.path & "\databaseName.mdb"
.Provide = "Microsoft.Jet.4.0"
.Open
end with
End Sub
Public Sub SetRS(SQL)
with rs
.ActiveConnection = con
.Source = SQL
.Open
end with
End Sub
On the Form_Load event, the connection to the database is made (assuming that your database is in the same folder as your program). What you can do with the SetRS function (it should probably be put into a module), is something like the following:
Assume that there are three text boxes on your form, and you'd like them to be updated when the user selects an option from the combo box. One's name is "Name", another is "Sex", and the third is "PhoneNumber". Assume also that the database fields are under the same name as the text fields, and that you are making your selection by the field's ID (table name is tblUsers).
Private Sub ComboBox_OnClick()
SetRS "SELECT * FROM tblUsers WHERE ID = " & ComboBox.text
Name.Text = rs.Fields("Name"
Sex.Text = rs.fields("Sex"
PhoneNumber.Text = rs.Fields("PhoneNumber"
End Sub
The "SQL" argument for the SetRS function allows you to set the recordset to your exact needs. So every time you need something different, you can call that SetRS function with a different SQL statement. Hope this is the kind of thing that you were looking for.
-----------------------------------------------
"The night sky over the planet Krikkit is the least interesting sight in the entire universe."
-Hitch Hiker's Guide To The Galaxy
