OpenArgs question

[cinnie]

hi to all

My form has a command button (cmdPrintRpt) and an unbound option group with
several option buttons. When I click cmdPrintRpt, it opens report rptSummary.

How do I pass the value of the option choice to the report using OpenArgs.
I can't seem to get the syntax correct in the DoCmd.OpenReport line.

Thanks
cinnie

 

[Allen Browne]

Try:
DoCmd.OpenReport "Report1", acViewPreview, OpenArgs:=Me.Frame1.Value

Option groups have a numeric value, so this will pass the OptionValue of the
chosen option button, or Null if no buttons are chosen.

Requires Access 2002 or later.

You could also read the option group's value from the report:
=Forms![Form1].[Frame1]

 

[cinnie]

Excellent

Have a happy New Year
--
cinnie

Try:
DoCmd.OpenReport "Report1", acViewPreview, OpenArgs:=Me.Frame1.Value

Option groups have a numeric value, so this will pass the OptionValue of the
chosen option button, or Null if no buttons are chosen.

Requires Access 2002 or later.

You could also read the option group's value from the report:
=Forms![Form1].[Frame1]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

hi to all

My form has a command button (cmdPrintRpt) and an unbound option group
with
several option buttons. When I click cmdPrintRpt, it opens report
rptSummary.

How do I pass the value of the option choice to the report using OpenArgs.
I can't seem to get the syntax correct in the DoCmd.OpenReport line.

Thanks
cinnie