Pass an invoice form field to a inventory table?

[Steve Schapel]

Brook,

Well, I didn't know you had a subform2 (frminventorysubform). And I
don't think you would be "passing" the invoicetype from
subform1(frminvoicedetails), would you? The invoicetype isn't in
invoicedetails, is it? It's in invoices, so it would be "passing" it
from the main invoices form, no? Yes, you can certainly do that, using
the kind of code you suggested... but, only for one subform record (i.e.
the active record) at a time. Which I guess means it has to be done at
the time of data entry of each invoice details item. Which is starting
to get closer to my earlier idea... make a query based on the
tblinventory and tblinvoicedetails tables, and use this query as the
record source of your subform, and then you can enter the status for the
inventory item via the subform, and then, if the status/invoicetype is
entered for the items, then there is no need for it to be entered for
the invoice itself, is it? So you might as well remove the invoicetype
field from the tblinvoices table, eh, because it is serving no purpose
there, is it? Because if the inventory items invluded in an invoice are
tagged with the sold/consigned status, then you automatically know the
invoicetype, without needing to store it in the invoices table, right?
Sorry, hope you understand what I am driving at.

 

[Brook]

Hello Steve,

I want to let you know thank you so much for all you have helped me with
and taught me along the way to figuring this out, but I have been able to get
my update query working properly and in the fashion that I need it to....

Thanks so much!

Brook

 

[Steve Schapel]

Brook,

I am pleased to know that you have made progress, and best wishes for
the rest of the project.