Complicated form / sub form question

  • Thread starter Thread starter RJB
  • Start date Start date
R

RJB

I've got a fairly complex form I'm trying to redesign to serve multiple
purposes and I've come to a roadblock. Basically, it is a print compnay job
log form that to this point was used to track jobs digitally, but work
orders were written up separately by hand, after the info was added to the
database. I'm trying to combine those 2 steps (logging and writing of
workorders) and am fairly close.

The problem I'm having is that the form has a log #. In a subform nested in
the form, I have a section for different jobs on that form (example: A
client orders 2 print jobs, 1 in color (job A) and 1 in black ink only (job
B)). The idea is to have them use the same log #, but have job A on a
separate page from job B since each job will be printed on a different
machine by a different person, but will be printed at the same time.

Any ideas on how to tackle that? Right now, the only option is to print the
work order twice and manually highlight which job letter is color vs which
is black and white.

I realize this is probably pretty hard to troubleshoot without having the
actual database - but I thought I'd put it out there and see if anyone has
any thoughts.

Thanks,
RJ
 
If the subform is linked to the main form by Log#, it should be pretty
straight-forward. Make sure the subform isn't a "continuous" form and
all should be fine, unless I'm horribly misunderstanding the issue.

If the problem is in the printout, create a report that's grouped by
Log# and Job#, and force a new page after the Job# (I think you do that
in the Sorting and Grouping section).
 
Back
Top