I have a command button to proccess required actions - check entries, set mail list, create mail...
I would like to add an option to pause this code if the user wants to print labels for the current record, and then procede with the rest of the code...
Select Case MsgBox("Would you like to print box address labels now ?", vbYesNoCancel, "print box labels")
Case vbYes
DoCmd.OpenForm "print box labels", acNormal, , , , acDialog
Case vbNo
'continue with proccessing
Case vbCancel
Exit Sub
End Select
This works but when I then when I preview the report it is under the print box labels form?