Option Group to reports

I have a query based form with the unbound ComboBox Customer Name and
other bound fields from joined tables. I would like to add a option
group with several choices like First Notice, Second Notice, Final
Notice.

For each Customer Name, I can select a Option Box choice like First
Notice and the move to the next
Customer Name and make a new Option Group selection, like Final Notice.


At the end of the session, I would like to use a command button to
print the First Notice, Final Notice reports for each Customer Name
which was assigned a Option Group selection.

I don't need to keep track of the Option Group selection after I print
the reports.

I have not been able to determine how to have the option group
selection associated with each customer name recorded until the session
is finished and the reports printed.

Thanks,

On 17 Jan 2005 11:26:00 -0800, wrote:

I have a query based form with the unbound ComboBox Customer Name and
other bound fields from joined tables. I would like to add a option
group with several choices like First Notice, Second Notice, Final
Notice.

For each Customer Name, I can select a Option Box choice like First
Notice and the move to the next
Customer Name and make a new Option Group selection, like Final Notice.

At the end of the session, I would like to use a command button to
print the First Notice, Final Notice reports for each Customer Name
which was assigned a Option Group selection.

I don't need to keep track of the Option Group selection after I print
the reports.

I have not been able to determine how to have the option group
selection associated with each customer name recorded until the session
is finished and the reports printed.

Thanks,

Simply add a new field to your underlying table.
Set the Field datatype to number, Field Size integer.

Add it to your query, then add an Option Group with 3 options, bound
to this new field, to the form.

When you select an option for each record, it's value will be stored
in the table.
To print reports showing just the option entered, you would set the
query criteria for that field to:
1 (or the value you chose for that option).

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Is there a way to do this without adding a field to the underlying
table? Perhaps adding a field to the query?

Thanks

fredg wrote:
On 17 Jan 2005 11:26:00 -0800, wrote:

I have a query based form with the unbound ComboBox Customer Name
and
other bound fields from joined tables. I would like to add a option
group with several choices like First Notice, Second Notice, Final
Notice.

For each Customer Name, I can select a Option Box choice like First
Notice and the move to the next
Customer Name and make a new Option Group selection, like Final
Notice.

At the end of the session, I would like to use a command button to
print the First Notice, Final Notice reports for each Customer Name
which was assigned a Option Group selection.

I don't need to keep track of the Option Group selection after I
print
the reports.

I have not been able to determine how to have the option group
selection associated with each customer name recorded until the
session
is finished and the reports printed.

Thanks,

Simply add a new field to your underlying table.
Set the Field datatype to number, Field Size integer.

Add it to your query, then add an Option Group with 3 options, bound
to this new field, to the form.

When you select an option for each record, it's value will be stored
in the table.
To print reports showing just the option entered, you would set the
query criteria for that field to:
1 (or the value you chose for that option).

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.