Option Group to reports

  • Thread starter Thread starter ionceti
  • Start date Start date
I

ionceti

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,
 
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,
Click to expand...

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).
 
Is there a way to do this without adding a field to the underlying
table? Perhaps adding a field to the query?

Thanks
 
Back
Top