Access 2007 – How to include option group on report

5 pts.
Tags:
Database programming
Microsoft Access 2007
Microsoft Access reports
Hello, I'm new to Access so please consider this when forming your response. This has been driving me crazy and I've looked high and low on the 'net for a solution. I look forward to your response. I have a form with an option group. I've wish to have this display on my report. Take for instance this "test" scenario: 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 running the report, a checkmark should appear within the box corresponding to the option selected on the form. Thank you for your time and expertise!

Answer Wiki

Thanks. We'll let you know when a new response is added.

I always put my variables in a seperate table (like printpara).
I attach it in the report query so that I have these on every line in my query and so I can put it where I want on my report. Like in your exemple, i would put it in the page header.
I you put it in only 1 record, you will have to write some code in the “On Open” to get these variables and keep/save them on your form.
Hope this can help you.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following