Reports recordset changes when i save the report in designview

  • Thread starter thomast via AccessMonster.com
  • Start date
T

thomast via AccessMonster.com

How can i save a report without Access messing up the reports recordsource?
The following case illustrates my problem:

DoCmd.OpenReport "Utstyrsutvalg", acViewDesign
Reports!Utstyrsutvalg.RecordSource = sqlStatement
DoCmd.Close acReport, "Utstyrsutvalg", acSaveYes

DoCmd.OpenReport "Utstyrsutvalg", acViewDesign
sqlAfterSave = Reports!Utstyrsutvalg.RecordSource

sqlAfterSave <> sqlStatement!! sqlStatement i pretty complex, but a valid SQL
statement, and the report works fine before i save it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change properties of all reports 6
Application defined or object defined error on report 8
opening report from form with variable recordsource 0
Help with report & subreport 4
opening report from form with variable recordsource 1
ACC2000: changing report .Filter does not work 3
Changing Report Margins from VBA code - Access 2007 1
PaperSize 15

Top