Hep needed with Option Buttons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to create a form that allows users to select on or more reports from
a list of different available reports. Option buttons seems to be a logical
control to use so that once the user has selected the report(s), then click a
command to either view or print the selected report(s). I've never used
option buttons which is why I'm posting this question. How do I make an
option button bound to a specific report? Is there any resources on what
code to write to make them recognized as selected when a view/print command
button is created?

Thanks in advance for any help!
 
I would create a table of reports with the object name and a friendlier
title. Use this table as the Row Source of a multi-select list box. You can
then run code in the on click of a button to cycle through the selected
items to run the appropriate reports.
 
Option buttons are most commonly used in Option Groups where you select one
option from the group. This is not a requirement, but the way they are
commonly used. You can use them the same way you use Check Boxes. The
problem is that even if you set the Default Value property to 0, the button
is greyed out, so it may be visually confusing to a user. You can test the
value of the button to see whether to print the report.

If Me.opbReport1 = True Then
DoCmd.OpenReport ....
End If
 
Back
Top