I might be barking up the wrong tree here but here is how I would do it:

Set the data controls properties to point at the table your querying.

Set the data source property of the text box(es) to point at the data control and the data field to the relevant field.

Before you run the app, remove the database and datasource properties of the data control, and in the form load event set the databasename property back to the data control (data1.databasename = "C:\myDB.mdb" etc...) Then when you build your query, set the recordsource property of the data control to the SQL query string and refresh the control. This should populate the control with the number of records returned and because you have data bound textboxes, the data control will update the text boxes as you scroll through the data.

Please accept my apologies if I've misinterpreted the question/problem.