How do you make the print preview window active?

[Hue]

I made a form (dialog) to enter begin and end date. and there i have a preview button calling the macro that will open my report. once preview button is pressed, the preview of the report will appear yet it isn't active. the dialog is the active window and not the preview of the report.

tried clicking on the preview report, still cant make it active.

any help on this will be appreciated.

 

[Hue]

ok ignore this thread...

i got it... it's on the window mode.

 

[WayneRyan]

Hue,

Don't use a Macro.

Base the report on a query. Have the query use the criteria
Between Forms![YourForm]![StartDate] And Forms![YourForm]![EndDate]

Then on the Command button put:

DoCmd.OpenReport "YourReport", acViewPreview

Wayne