a couple issues with printing a tab

[JimMuglia]

Greetings,

I have written a database, with a form interface. The form consists of a tab control, with two tab pages of data on them.

First issue.

When I print it out, only the first tab page prints, and it prints twice.

What would be the proper command for me to use, in order to get both tab pages to print?

Here is the print function as it stands right now:

Private Sub cmdPrint_Record_Click()
On Error GoTo Err_cmdPrint_Record_Click
 
 
    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.PrintOut acPages, 1, 12
 
Exit_cmdPrint_Record_Click:
    Exit Sub
 
Err_cmdPrint_Record_Click:
    MsgBox Err.Description
    Resume Exit_cmdPrint_Record_Click
    
End Sub

Once I resolve the first issue, I will let you know the second issue.

Thanks,
Jim

[westconn1]

is this dot net?

pete

[si_the_geek]

Nope, it's VBA for Access.. moved to appropriate forum.