How to read a Recordset into a table/form/report?

[Guest]

Hi,

I have a recordset from a ActiveX control. Now I want to save the recordset
into a table and display it using a form/report. The table, Form, and Report
are created in run-time. How to do it? Thanks for any help.

Yolande

 

[MacDermott]

Unlike some other applications, Access works best when objects are created
in Design View and not at run time.
Assuming that your ActiveX control always returns a recordset in the same
format, you can "pre-create" the table.
When you need to fill it from your recordset, simply run a delete query to
empty out its current contents, then step through your recordset row by row,
appending data to the query.
You can also "pre-create" your form and report, and bind these to the table.

HTH
- Turtle