User friendly overview of employees and their tasks

[Outzen]

Im trying to build a form giving an overview of emplyees and their assigned tasks including deadlines.
I could gather this information in one big recordset, however in order to improve readability I would like to list the emplyee name once, and for each emplyee show tasks and deadlines.
I have tried to google a pure sql solution, however think I will probably need to solve this via vba instead - by creating multiple recordsets, looping through each emplyee and then somehow dynamicly add multiple subforms/unbound control boxes to a form?
Any ideas how I should approach this?

rgds
Jakob Outen

 

[AccessMSSQL]

Are you trying to read data from an existing SQL Database and populate the data into a form?

 

[Outzen]

Are you trying to read data from an existing SQL Database and populate the data into a form?

Yes, its a "pure" access 2010 setup

 

[AccessMSSQL]

Why don't you just use odbc to connect directly to the SQL database - link the sql tables (assuming your database has Employee table and Employee Tasks table, etc. Just link to these tables and create your forms based on the linked tables. You don't need unbound textboxes and recordset looping to create anything dynamically.