displaying recordset results from vba

[gregb]

Hi.

(this is s repeat post from the queries topic)

I am building a form for people to use to analyse the data
in my Access2000 database. The SQL is built up in VBA
depending on control values set in the form. How do I
display the resulting recordset to the user? I have used a
create-table query and then used DoCmd.OpenTable but I
would also like to view crosstab results.

I am using DAO at present. Is their a method that will
give a datasheet-like view for a Recordset? Might I have
to build a form using the field list from the recordset
and then copy the recordset into the form?


Cheers,

Greg

 

[Douglas J. Steele]

Can you not just use the SQL you've created as the Recordsource for the
form?

 

[Guest]

Hi Doug.

Thanks for your reply. I tried that, but it seemed to want
an object name rather than an explicit SQL statement.

Cheers,

Greg.