Repost - Printing out Form with Subform

  • Thread starter Thread starter Edm
  • Start date Start date
E

Edm

Hi,

Someone on this forum was gracious enough to attempt to
provide a solution to my problem, however unfortunately it
didnt work out, so here I am again.

I have a Main form which displays static billing
information for each manufacturer I deal with. Embedded
in this form is a subform which tracks servicing I do for
that manufacturer. What I am attempting to do is create
an invoice which displays manufacturer billing info on
top, and then the subform with just one service call per
printed invoice.

Whats happening now is that the manufactuerer (main form)
selects just fine, but the service call forms dont select
individually for printing. Instead all of them are
selected at once to go to the printer. This can be a
huge problem when dealing with hundreds of service calls.

I need a way to select just the manufacturer, and just 1
service call to print to this invoice at a time, creating
a 1 page invoice consistently.

Does anyone know how to do this?

Unfortunately I need to track the service calls in an
independent form because the call status is updated to an
eventual closed and paid status.

Thanks,

Edm
 
When you create your report(invoice), it seems to me you would tell it which
service call to print. Since you would only tell it to print one, only one
would appear on your invoice. In the query (upon which your report is
based) you'd pull the service call information and you'd also have the
vendor table in your query and a relationship so the appropriate vendor data
is pulled.

Sounds like you just need to be telling the query which service call to pull
and you are currently only telling it which vendor to pull.

To solve, simply have the user indicate which service call as well.

Rick B


Hi,

Someone on this forum was gracious enough to attempt to
provide a solution to my problem, however unfortunately it
didnt work out, so here I am again.

I have a Main form which displays static billing
information for each manufacturer I deal with. Embedded
in this form is a subform which tracks servicing I do for
that manufacturer. What I am attempting to do is create
an invoice which displays manufacturer billing info on
top, and then the subform with just one service call per
printed invoice.

Whats happening now is that the manufactuerer (main form)
selects just fine, but the service call forms dont select
individually for printing. Instead all of them are
selected at once to go to the printer. This can be a
huge problem when dealing with hundreds of service calls.

I need a way to select just the manufacturer, and just 1
service call to print to this invoice at a time, creating
a 1 page invoice consistently.

Does anyone know how to do this?

Unfortunately I need to track the service calls in an
independent form because the call status is updated to an
eventual closed and paid status.

Thanks,

Edm
 
Back
Top