I have a form on which is a button to click to bring up a report from which I'd like the user to be able to print the report. The code I have on the button is as follows:
Private Sub Command40_Click()
DoCmd.OpenReport "DA2062_New", acPreview, "[ID] = " & Me![ID]
What I'm getting is that the report does open in print preview mode, BUT, first, it opens up beneath all my other open forms as opposed to right on top, so with the other forms which are open at the time a user may not even realize the report even opened, and second, the actual print button in the print preview menu bar is greyed out and doesn't let the user actually click it to print the form. Can somebody please help me correct this code to do as it should. Thanks.