Report preview issues

[GUIDO22]

Hi
I have a report that runs from a dialog where the user has the option to print out or preview. This has worked fine for many months.
Yesterday i had reason to change a label on the report , to a text box whose control source is a text box on the parent dialog from where the report is initiated.
This simple change has resulted in preview no longer working, however sending direct to printer works fine.

I have recompiled the whole project and also run compact on the db too. No change, preview won't work.
So i have had to reinstate from a backup the original report which of course still works fine.

Any ideas why this seemingly simple change is giving me this issue, is there anything i may have overlooked?

Thanks in advance.

 

[June7]

No idea. Never encountered this. Might post db for analysis.

 

[arnelgp]

what is the "ControlSource" of the textbox?

 

[GUIDO22]

what is the "ControlSource" of the textbox?

Hi again!
The parent dialog has a few text fields for user entry and although these are saved to a table, other fields on the form are calculated values based on that user data (that aren't and because they are calculated do not need to be stored). It is one of these calculated values in a text box on the parent form that i am referencing in the text box on the report...

 

[arnelgp]

so your textbox in the report has a ControlSource like:

=[Forms]![dialogFormName]![theTextbox]

what if the Dialog form is opened as Pop-up only and not as acDialog?

 

[GUIDO22]

I'm not sure of the distinction in what you suggest..
its called using: docmd openform (acdialog?)
But the relevant form property is set to popup also..

 

[arnelgp]

I'm not sure of the distinction in what you suggest.

what i suggest is you try to open your form without acDialog.

 

[GUIDO22]

Hmm... weird...
So I took a copy of the database with the erroneous Report ... and gradually started removing controls and trying to preview each time.. no joy..
Eventually, there were no controls left... even then.. it still wouldnt preview!

So, as a somewhat last resort I decided to try this ... I created a brand new report and simply copied the controls over from a backup copy of the report into the new one.. Bingo! It now displays as expected... (wtf?)