A
Ayo
How do I tell the program to enable the comand buttons on my form when either
of the option buttons on the for is checked?
I am trying to write a code that would enable some buttons on my form when I
select one of two option buttons. So far this is what I have and it is not
working quite as I hoped. Any help will be greatly appreciated.
Thanks
Private Sub AllReviewerReport_Click()
Dim strReport As String
'if optPortrait.
Forms![Invoice Tracker Reports]!AllVendorReport.Enabled = True
Forms![Invoice Tracker Reports]!AllReviewerReport.Enabled = True
Forms![Invoice Tracker Reports]!VendorReviewerReport.Enabled = True
Select Case Me.optgrpOrient
Case 1
strReport = "Reviewer Report"
Case 2
strReport = "Reviewer Report Landscape"
End Select
DoCmd.OpenReport strReport, acViewPreview
'DoCmd.Close acForm, "Invoice Tracker Reports"
End Sub
of the option buttons on the for is checked?
I am trying to write a code that would enable some buttons on my form when I
select one of two option buttons. So far this is what I have and it is not
working quite as I hoped. Any help will be greatly appreciated.
Thanks
Private Sub AllReviewerReport_Click()
Dim strReport As String
'if optPortrait.
Forms![Invoice Tracker Reports]!AllVendorReport.Enabled = True
Forms![Invoice Tracker Reports]!AllReviewerReport.Enabled = True
Forms![Invoice Tracker Reports]!VendorReviewerReport.Enabled = True
Select Case Me.optgrpOrient
Case 1
strReport = "Reviewer Report"
Case 2
strReport = "Reviewer Report Landscape"
End Select
DoCmd.OpenReport strReport, acViewPreview
'DoCmd.Close acForm, "Invoice Tracker Reports"
End Sub