Check box used in Macro

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

Guest

Hey all,

Just trying to figure out how to use a check box's value when deciding which
report to print from a form. The form has a print preview button, with an
option group to determin WHICH report to print. The option group is called
Report to Print... each option is given a value, from 1 to 4, for each report

The button is linked to a macro group called Print Reports.PrintPreview
In this macro, the condition clause is set up to accept an option group
number, and determins which report to print.. say for report 1:
Condition: [Report to Print]=1
Action: OpenReport

Now, I have a check box to decide whether to print a specific version of the
report... there is 2 versions, one not sorted by date (currently used now),
and ones that ARE (new reports)... I want a check box used to determine to
print which version... check = print date sorted report, check <> print
original report..
The check box's name is Date Check

In the macro, i was thinking along the lines of:
Condition: [Report to Print]=1 & [Date Check]=-1
Action: OpenReport

But it doesn't seem to work.. any suggestions??
Cheers
 
The value for a checkbox when selected is 1, Yes or True
when it's selected. Check your table for the data format
being saved.
-----Original Message-----
Hey all,

Just trying to figure out how to use a check box's value when deciding which
report to print from a form. The form has a print preview button, with an
option group to determin WHICH report to print. The option group is called
Report to Print... each option is given a value, from 1 to 4, for each report

The button is linked to a macro group called Print Reports.PrintPreview
In this macro, the condition clause is set up to accept an option group
number, and determins which report to print.. say for report 1:
Condition: [Report to Print]=1
Action: OpenReport

Now, I have a check box to decide whether to print a specific version of the
report... there is 2 versions, one not sorted by date (currently used now),
and ones that ARE (new reports)... I want a check box used to determine to
print which version... check = print date sorted report,
Click to expand...
check said:
original report..
The check box's name is Date Check

In the macro, i was thinking along the lines of:
Condition: [Report to Print]=1 & [Date Check]=-1
Action: OpenReport

But it doesn't seem to work.. any suggestions??
Cheers
.
Click to expand...
 
Actually, the value of True in ACCESS is -1. False is 0.

--

Ken Snell
<MS ACCESS MVP>

Bob said:
The value for a checkbox when selected is 1, Yes or True
when it's selected. Check your table for the data format
being saved.
-----Original Message-----
Hey all,

Just trying to figure out how to use a check box's value when deciding which
report to print from a form. The form has a print preview button, with an
option group to determin WHICH report to print. The option group is called
Report to Print... each option is given a value, from 1 to 4, for each report

The button is linked to a macro group called Print Reports.PrintPreview
In this macro, the condition clause is set up to accept an option group
number, and determins which report to print.. say for report 1:
Condition: [Report to Print]=1
Action: OpenReport

Now, I have a check box to decide whether to print a specific version of the
report... there is 2 versions, one not sorted by date (currently used now),
and ones that ARE (new reports)... I want a check box used to determine to
print which version... check = print date sorted report,
Click to expand...
check said:
original report..
The check box's name is Date Check

In the macro, i was thinking along the lines of:
Condition: [Report to Print]=1 & [Date Check]=-1
Action: OpenReport

But it doesn't seem to work.. any suggestions??
Cheers
.
Click to expand...
Click to expand...
 
Back
Top