I have a large number of subforms which I want to get their data from different tables in an OMNIS backend datafile. I have worked out how to connect to the datafile and create a single ADO recordset which links to one of the subforms. What is the best way to create recordsets for all the other tables required and how do I link each subform to its relevant recordset. Ideally I would like all the recordsets created when the database is started so the majority of the wait time is on opening the database, not when opening each individual subform.