text box
hooby1,
In design view open the properties box for your textbox. Click on the tab that says Data. The ControlSource is where you enter the details of what you want to bind the control to.
To select the bit you want click on the "..." to open the expression builder then work your way through to your query and select the field, from the relevant query, that contains the data you want.
Hopefully that should do the trick for you.
regards
Ian