advanced micorosoft access training - Option groups

Hi Jane

I believe what you are saying is that you have a form, which is the front end of to a table. When you select one of the option on the form, the value that is associated with that option is input into the table. By this I mean that if the option confirmed is selected, this is then input into the table. So why don't you just set up the report so that it takes the data out of the table. It is important to remember that the table holds all of the data, the form itself holds no data at all, it is just an interface for a table. So on the report why not just use the text box and then link it to a query that is carried out on the the table itself. I am not sure exactly what you are trying to show, but if you are trying something along the lines of showing where an order is confirmed or pending, you will need to perform a query on the table to pull out all of the data that you need and then use a report to display all of this data.

So you do not need to worry about the option buttons as the report will be getting the data directly from the table, which will only hold one of the two values. So when taking the data from the query and placing it into a report you will be displaying the exact values held with the database table and not the two option that it could be.

I am sorry I did not pick this up before

Hope this solves your problem

David