Store a field value from one table in a field in another table

[1953hogan]

Hi,



Working on a simple invoicing database for our small company. I realize there are tons of templates for this but I'm trying to teach myself as well, so
i have what is probably a simple question. Here are my tables:



I've got an invoice form set up with invoice details subform and it works perfectly to create new invoices, but the subform is using the [Products].[Price] field, so any future price changes to products will result in changes to past invoices which we don't want.

So, when an invoice is created and the InvoiceDetails table is populated, I'd like to store the [products].[Price] field into [invoicedetails].[PriceStored]. That way, historical invoices won't be affected by current product pricing.

I've messed around with combo boxes for this without success. I'd be very appreciative for any help or ideas. Thanks very much.

Steve

[ranman256]

update query.
youd run a query to update the field value from one table and update your current record.

[1953hogan]

update query.
youd run a query to update the field value from one table and update your current record.

Thank you. Can I set that up as an event to run when I enter the invoice?

[1953hogan]

Seems complicated. Any other ideas or can somebody walk me through this? Thank you.

[davegri]

Deleted, forgot that there could be many products shown on subform, my code covered only one.

[1953hogan]

I've got the update query working. Thanks for the help!