Access 2007 Display Option Group on report

[tuxalot]

New to Access so please go easy. I have a form with an option group. I've wish to have it's result display on my report.

options a, b, c

I've created a field in my table to accept the data from the form. In my table, I see 1, 2, 3 when I save a record. Good enough. Now, in my report, I wish to have checkboxes representing options a, b, and c. When opening the report, a checkmark should appear within the box corresponding to the option selected on the form.

Thank you for your time and expertise!

[missinglinq]

I assume something this basic hasn't changed in 2007. It's actually quite easy. In Report Design View, place an Option Group on your Report, just like you did on your Form. Simply follow the Wizard and enter your selections for the labels, select a display type (checkboxes, option boxes, etc) and then, in the appropriate screen, select Store the value in this field and use the dropdown to pick the appropriate field.

Welcome to Bytes!

Linq ;0)>

[missinglinq]

Tuxalot, I'm glad you've resolved your problem. Since your last post was actually for a separate, new problem I've split it off into a separate thread titled Count Option Group Selection on a report.

Linq ;0)>

Moderaator