Option Group in a Report

[Guest]

I am trying to create and option group in the page header by selectin the
option group from the tool box and draggin the field from the field list. I
did all the steps as the wizard tells me. when I ran the report the option
group is not working and no option button were selected. Option button should
be mapped to the underlying query, any suggestions?

 

[Larry Linson]

"Mohammad Zaky, CMA" wrote

I am trying to create and option group
in the page header by selectin the option
group from the tool box and draggin the
field from the field list. I did all the steps
as the wizard tells me. when I ran the
report the option group is not working
and no option button were selected. Option
button should be mapped to the underlying
query, any suggestions?

When you say "Option Button should be mapped to the underlying Query," what
do you mean. If you have created a Frame and placed Option Buttons inside,
it is the Frame that will be "mapped to a value in the underlying Query."

I can place a Frame with Option Buttons in a Page header, and it works just
fine for me. That is, it displays the button checked that matches the option
group value of the first Record of that page. Is that your intent? If not,
please clarify.

Page Headers and Footers are not associated with a particular record -- they
will get their values, if pertinent, from whatever Record is active at the
time; Fields in the underlying Query are in a particular Record and specific
Records are associated with the Detail Section of the Report.

Larry Linson
Microsoft Access MVP

 

[Guest]

Larry,

That is exactly my intent, I want to put an option buttons in a frame and
the button should match the first record. I am using the wizard to do so.

If I drag the field from the field list in the page header it got the
information right for me, and I find the information in the header matching
the records in the detail section. When I tried the option group frame it
doesn't work and it didn't even mark any option buttion of the four buttons I
created.

Thanks for your help.