You would need to have the appropriate fields in the "child" table to store
the values. Typically the combo box for the products/services would contain
columns for the price. The after update event of the combo box would have
code to set the value of the price field like:

Me.txtPrice = Me.cboProdService.Column(1)

Columns are numbered from 0.

--
Duane Hookom
Microsoft Access MVP


"dvvog" wrote:

I am using Access 2007. I have a database for my Products/Services industry.
I have a table containing my products/services, as well as a Work Order Form
that is linked to the Products/services table from which I can choose via
drop down the products that I am selling to that customer. The
Product/services table contains 3 fields; Product, Cost & Price. The Work
Order Form also contains those three fields, and when I choose a product from
the drop down, the corresponding Price field fills in as well. Now, sometimes
(after bargaining of course!) I want to change the price for that specific
work order without it affecting the main Products/services table, can anyone
help?