Update two fields from one Combobox selection

[Mannie G]

I have a form in a Stock control system where I want to be able to look up a
part number from table 'Parts' and store the part number AND the price in the
'PartsTransaction' table. The information in the 'PartsTransaction' table
store all the information on the purchase, sales, receipts and adjustements
for every part.

When a new order is raised a sub from in the Purchase Order Form has a
combobox look-up to select the parts for order. I would like the
'PuchasePrice' in the subform to have the default value of the price in the
parts record for the item selected when selecting the part no in the
combobox. However, it will also be necessary to overide the default price in
case of a price or exchange rate change.

Can anyone help please?

 

[molsonexpert]

I find your actual question a little confusing, but from the subject header,
is something like this what you're after?

http://www.mvps.org/access/forms/frm0058.htm

 

[Mannie G]

Hi

Just what I was looking for!!
--
Thanks

Mannie G

I find your actual question a little confusing, but from the subject header,
is something like this what you're after?

http://www.mvps.org/access/forms/frm0058.htm