Creating Access Report in VB

[becshu]

I currently have a report linked to a query. This query is created in VB and the fields and numbers of fields are always changing. The report doesn't show the new fields each time the query is altered. Is there a way to create a report in VB so I can be sure to have the correct fields each time I run the macro to show it?
Thanks!

 

[PHV]

You may take a look at the Application.CreateReport method.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[becshu]

If I use Application.CreateReport can I link it right to a query, or do I have to set the recordset for the report? I'm sure I could do the latter, but the former would save a lot of time since the query is already created.