HOW DO I: Add or Launch Report from a Form?

[ba1959nh]

I have an Access 2003 form and I have created a Report.


I cannot figure out how to put the Report or a way to launch it on my Form.

Also.......
I need to pass a Date to the Report.
I have a Date Picker and Launch button on my Form.
I just can't find the control for a Report.

I appreciate any help.

[swampdonkey]

When you choose a command button the command button wizard should pop up. on it choose report operations. Simpliest way i know how.

[ba1959nh]

Thanks....
I finally got it.
Instead of PASSING the data, the Query reads it from the Form textbox.

Below is relevant code:

QUERY: GetPastDueWithDateParam [SQL View]
SELECT Owners.PermissionRenewalDueDate, Owners.*
FROM Owners
WHERE (((Owners.PermissionRenewalDueDate)<[Forms]![Permission Form]![txtRenewalDateCompareDate]));


REPORT: GetPastDueByDateRpt

FORM: Permission Form
VBA Code:
'********************************************
' Launch the GetPastDueByDateRpt Report
'********************************************
Private Sub btnLaunchRenewalDueRpt_Click()

On Error GoTo Err_btnLaunchRenewalDueRpt_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "GetPastDueByDateRpt"
' IMPORTANT: Do NOT delete EMPTY params (commas) in the DoCmd.OpenReport call
DoCmd.OpenReport stDocName, acViewPreview, , , acWindowNormal

Exit_btnLaunchRenewalDueRpt_Click:
Exit Sub

Err_btnLaunchRenewalDueRpt_Click:
MsgBox Err.Description
Resume Exit_btnLaunchRenewalDueRpt_Click

End Sub
'********************************************


I hope that somone finds this useful.