Hello,
I have a form with two tab pages. One picks data from a table, the second one has unbound fields that once updated are saved into a different table.
I am having problems in printing this second page.
I have tried two options:
1) The following command: DoCmd.PrintOut acSelection
2) The following code: Dim myform As Form
Dim pageno As Integer
pageno = Me.CurrentRecord
Set myform = Screen.ActiveForm
DoCmd.SelectObject acForm, myform.Name, True
DoCmd.PrintOut acPages, pageno, pageno, , 1
DoCmd.SelectObject acForm, myform.Name, False
IN both cases, I am able to print but the tabs get stuck and cannot move from one to the other.
Will appreciate any help. Thank you
I have a form with two tab pages. One picks data from a table, the second one has unbound fields that once updated are saved into a different table.
I am having problems in printing this second page.
I have tried two options:
1) The following command: DoCmd.PrintOut acSelection
2) The following code: Dim myform As Form
Dim pageno As Integer
pageno = Me.CurrentRecord
Set myform = Screen.ActiveForm
DoCmd.SelectObject acForm, myform.Name, True
DoCmd.PrintOut acPages, pageno, pageno, , 1
DoCmd.SelectObject acForm, myform.Name, False
IN both cases, I am able to print but the tabs get stuck and cannot move from one to the other.
Will appreciate any help. Thank you