Formatting Page Problem

[Angelique21]

Hey maybe someone can help me...

When running a report, sometimes I get Formatting Page..Press CTRL+BREAK and then gets stuck. This is happening when the report runs and I have to move to Page 2 or Page 3 of the Report.

Any suggestions about it.

Thanks.

 

[maxhugen]

The msg 'Formatting Page...' in the Status bar means that Access is formatting the layout of the report. There are several things that will slow this down, esp in a large report (many pages), eg referencing a report total within the report detail, etc.

Have you any code running in the report?
Are you using any domain functions like DLookup, DMax etc?

Max Hugen
Australia

 

[Angelique21]

Hi yes it is actually referencing a report total within the report detail..

but now what is happening is that it runs the report correctly and when i press from the navigation menu PAGE2, a run time error no 2450 message box is displayed, telling me form not found.


cannot understand why it works for only one page and when i try to access page2 it stops like this..


any suuggestions?!

thanks a lot

 

[dhookom]

What form isn't found? Are you closing a form when you open the report?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Angelique21]

Yes I am closing a form when the report opens.

The exact situation is this I have a form (FORM1), where the user chooses the Order No and then another form opens (FORM2) where the user chooses the type of Preview to view and finally the Report Opens. On the second Form i am closing BOTH forms.

Now when having more than one page, it is giving me:
run time error no 2450 message box is displayed, telling me FORM1 not found.

 

[dhookom]

Don't close the forms until at least after the report closes. Consider setting the form's Visible property to False.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]