Form/Subform

  • Thread starter Thread starter Brook
  • Start date Start date
B

Brook

I am setting up a billing/invoicing database based on a
client table and an inventory table. When I pull up my
form (clienttable)/subform (inventory), I choose the items
that I want on the invoice from the inventory subform.
What I would like to do is set up an invoice/report to
pull the data from the form/subform and once the report is
closed the form/subform reset, and the client is added to
my invoice table and inventory table (as a sold item).

Does anyone have any tips or suggestions on how to
accomplish this? or know of any sample databases I could
take a look at?

Brook
 
Back
Top