A list of all jobs performed is maintained in a log report binder that go back decades. (356 pages and counting) The real old jobs are unassigned and coded 99 just so the field isn’t left empty. The newer jobs are coded 1-7 via an option box on the job input form.
When a new job comes in, all of its job info is handwritten on next line of the log including making one selection for the type of job. (There are 7 columns on the print out and only one can be checked)
Here is a sample of the heading on my report
JOB# CLIENT LOCATION Type1 Type2 Type3 Type4 Type5 Type6 Type7
X
The job info is then entered in an Access form that contains an option box that handles the 7 job types so that the user can only select one. Once done, only the last page of the log needs to be reprinted.
My question is:
How do I get the option box to display all of its options in a report like above?
I tried 7 unbound text boxes and using a Select Case on the OnFormat event but all seven of the boxes get checked for each job.
When a new job comes in, all of its job info is handwritten on next line of the log including making one selection for the type of job. (There are 7 columns on the print out and only one can be checked)
Here is a sample of the heading on my report
JOB# CLIENT LOCATION Type1 Type2 Type3 Type4 Type5 Type6 Type7
X
The job info is then entered in an Access form that contains an option box that handles the 7 job types so that the user can only select one. Once done, only the last page of the log needs to be reprinted.
My question is:
How do I get the option box to display all of its options in a report like above?
I tried 7 unbound text boxes and using a Select Case on the OnFormat event but all seven of the boxes get checked for each job.