Access97. I have a form that uses a tab control to create two pages (two tabs).
I have a 'Print' button on each page that, when clicked, will print the data on the page.
The user can tab to either page and then print the page. I would like to set it up so that the user can print the current page or both pages with either of the Print buttons.
I would like to change the print buttons so that when clicked, the user would get a message box with two radio buttons plus an 'OK' button and a 'Cancel' button.
The radio buttons would be:
1. Print current page only
2. Print both pages
Currently, I have both Print buttons set up in 'Properties\Event\On Click\[Event Procedure] as follows:
Private Sub PrintButton_U_Click()
On Error GoTo Err_Print_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.PrintOut acSelection
Exit_Print_Click:
Exit Sub
Err_Print_Click:
MsgBox Err.Description
Resume Exit_Print_Click
End Sub
What must I do to make the desired change? Thanks in advance.
Lou Marles
I have a 'Print' button on each page that, when clicked, will print the data on the page.
The user can tab to either page and then print the page. I would like to set it up so that the user can print the current page or both pages with either of the Print buttons.
I would like to change the print buttons so that when clicked, the user would get a message box with two radio buttons plus an 'OK' button and a 'Cancel' button.
The radio buttons would be:
1. Print current page only
2. Print both pages
Currently, I have both Print buttons set up in 'Properties\Event\On Click\[Event Procedure] as follows:
Private Sub PrintButton_U_Click()
On Error GoTo Err_Print_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.PrintOut acSelection
Exit_Print_Click:
Exit Sub
Err_Print_Click:
MsgBox Err.Description
Resume Exit_Print_Click
End Sub
What must I do to make the desired change? Thanks in advance.
Lou Marles