noob with Textbox and subform/subreport problems

[Trees]

I am making a from that has a set of combo boxes that allow the user to search through a table. the results are displayed in a subform / subreport window that is set to a query. the search works by changing the SQL of the query. I have spent weeks on getting this far and i have decided to just show some key infomation in the subreport window.

What i want to do now is to display further infomation from the query row that is selected by the user in a textbox on the form.

i have been looking in the access VBA help,an access programming book and in the forum .And found that it is something to do with the recordset and making the text box bound but i cant find any examples where it is applied in this way.

the problem is (i think) that i would like the text box data to change when the user selects differnt rows so would this change what the textbox is bound to.

I hope it is possible and if anyone can help it will be greatfully recived

Trees

 

[Trees]

i have managed to get a set of text boxes to show the results of the query but it only shows the data on the record that is chosen in the little record box at the bottom of the form .

is there a way to syncronize the number in the record box of my subform displaying my table and the number on the form that controlls the text boxes????