I'm developing a data retrieval application in Access 2010 VBA in which the user chooses from lists of tables, fields, and rows. VBA code generates a SQL statement from the user's choices in listboxes and then opens an ADODB.Recordset. So far so good.

How may I best display the recordset data? I'd like to use a grid or datasheet view but I can't figure out how to do this. Access 2010 won't accept any grid control I've tried and subforms just aren't made for this purpose. Can anyone out there tell me how to get this done?

I would just use a form with its default view set to Continuous Forms and its recordsource set to your query. This way I could program events behind each field displayed if I wanted.

I agree. Use a form bound to the SQL.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015