Create a autoform autoreport in code 1

[PWise]

Hi everyone
I have a query that the number of fields change dynamically
with
currentdb.querydefs("queryname&quot.sql = sqlstr
the next line of code is
docmd.openquery "queryname"

can anyone pleae help me with some code to create a autoform
or autoreport to be able to view the code in a form
thanks

 

[ajdesalvo]

The following code will open the query in the QBE grid, showing it first as a report:

docmd.openquery "queryname", acViewPreview

Code On! Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"