print preview

[Guest]

i have a form that has tab controls named "VQC", "CCC" and "VHC". The print
preview icon is on the main form. If VQC is current, print preview should
open vqc_report, if CCC is current, it should open ccc_report and so on. What
should i place in my if and then statements?

If VQC ???? then
stDocName = "vqc_report"
else......

thanks!

 

[ruralguy via AccessMonster.com]

If your Tab Control is named TabCtl99 then:

Select Case Me.TabCtl99.Pages(Me.TabCtl99).Name

Case "VQC"
stDocName = "vqc_report"
Case "CCC"
stDocName = "ccc_report"
Case "VHC"
stDocName = "vhc_report"
Case Else
End Select

DoCmd.OpenReport.....

 

[Guest]

thanks!

If your Tab Control is named TabCtl99 then:

Select Case Me.TabCtl99.Pages(Me.TabCtl99).Name

Case "VQC"
stDocName = "vqc_report"
Case "CCC"
stDocName = "ccc_report"
Case "VHC"
stDocName = "vhc_report"
Case Else
End Select

DoCmd.OpenReport.....

 

[ruralguy via AccessMonster.com]

You're welcome.

thanks!

If your Tab Control is named TabCtl99 then:

[quoted text clipped - 21 lines]