Creating an Invoice

[Brook]

I have a tblclients and a tblOrders, the tblOrders
contains a listing of all my orders both inhouse and for
clients. I don't create invoices at the time of orders, so
what I am trying to do is set up an invoice form that I
can choose the records for each client (which could be 1
record or 100 records) and then create an invoice for
those records. I am stumped on what to do next.

Thanks

Brook

 

[Michel Walsh]

Hi,

Make a report that does the invoice paper form. The report would make a
GROUP on client, and "force" a page break at the end of the footer of the
group (so each client, or invoiceID, would have its own "paper").

The data to make the record would probably involve join, may be not, so
build a query to get all the data, and use that query as source for your
report. See http://www.mvps.org/access/forms/frm0007.htm for an example on
how to use a multi-select list box in a where clause of a query.


Hoping it may help,
Vanderghast, Access MVP