I could sure use your help with the VB code to print only one page, the details are below:
Report name: SHEMA Form
Presently I have a button that uses the following code, but the report prints a duplicate page for each of the line items associated with the "Key" field, which is "PRNumTemp".
Private Sub Command12_Click()
Dim strWhere As String
If Me.Dirty Then 'Save any edits.
Me.Dirty = False
If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print"
strWhere = "PRNumTemp = '" & Me.PRNumTemp & "'"
DoCmd.OpenReport "SHEMA Form", acViewReport, , strWhere
So if you have a good suggestion, I'm all ears, but at least provide the code for printing only one page, please and thank you.