Access 2007 – How to include option group on report
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!
Software/Hardware used:
Software/Hardware used:
ASKED:
February 1, 2009 5:55 PM
UPDATED:
February 2, 2009 1:48 PM
RELATED QUESTIONS
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
