Hi All,
Currently I have an Access 97 database which collects the results of 
testing various pieces of equipment.  An access front end has been 
developed - mainly by wizards - so uses can just view the data, hence DAO 
and bound controls.
I am looking to upgrade the database to SQL Server yet still use the 
access front end.  I have noted with interest the recommendations in 
various books published by WROX that the way to go for scalable solutions 
is to use unbound controls for the front end.
The problem I have at the moment in adopting this strategy is on one 
particular form. This form has a subform with an underlying query that 
produces 77 records. One set of bound text boxes (one for each of the 
fields in the table) on the subform in the detail section produces all 77 
records to the user, scrollable without using the navigation bar.
I cannot at the moment find a way to "unbound" these text boxes and 
populate them with the recordset produced from a similar SQL query.  Is 
there a way to do this???? 
Thanks
db1