I need to Open a Report as a dialog window in ACCESS 2000. I know I
can use the Dialog option on ACCESS XP and above. However, the
OpenReport on 2000 does not have that option. What can I do to Force a
report into a dialog mode, where code after the OpenReport (in Preview
mode) does not execute until the user closes the report?

have you tried moving the "after" code to the report's Close event?

hth


"Pete" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I need to Open a Report as a dialog window in ACCESS 2000. I know I
> can use the Dialog option on ACCESS XP and above. However, the
> OpenReport on 2000 does not have that option. What can I do to Force a
> report into a dialog mode, where code after the OpenReport (in Preview
> mode) does not execute until the user closes the report?
>

The after code is inside a form. The openreport command is inside a
loop allowing the user to view multiple sets of data as reports.

Without a way to stop the process, I wind up with numberous report
windows active behind the form window and the user does not see them
unitl the form is closed.

The after code is inside a form. The openreport command is inside a
loop allowing the user to view multiple sets of data as reports.

Without a way to stop the process, I wind up with numberous report
windows active behind the form window and the user does not see them
unitl the form is closed.

no other suggestions for you, sorry.


"Pete" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> The after code is inside a form. The openreport command is inside a
> loop allowing the user to view multiple sets of data as reports.
>
> Without a way to stop the process, I wind up with numberous report
> windows active behind the form window and the user does not see them
> unitl the form is closed.
>