Using VB code in Access

[MrYoda]

Using Visual Basic in Microsoft Access does anyone know how to use a command button to print a predefined Report?

I need to print a report based on the month a user provides (I'm using an InputBox for this). Once they enter the month I need to (using VB code) run a query and run a report. I want this automated so the user only has to click on the button and supply the month. I don't know how to link a CommandButton to a Report in Access. Any help would really be appreciated.

[Bash]

try

DoCmd.OpenReport "rptName",acViewPreview,,"[Month]='" & sMonth & "'"

You must have your query saved as the record source of the report... it doesn't need to have month as a parameter but it has to have the Month field in the select

Bash