Re: auto update form value

On Feb 15, 6:08 pm, "Phil" <no-...@xxxxxxxx> wrote:
Hello,

I have a sales form, order details, that shows Product ID, quantity, Unit
Price, etc. I have a Products table, Products, that has Product ID, Stock
Level, Unit Price.

What i would like to do is automatically insert the unit price into the
sales form depending on the Product ID that is entered into the sales from.

Can anybody please explain to me how to do this ?

Thank you

The method you use will depend on what type of control Prodcut ID is.
If it's a combobox or listbox (If a textbox I would consider changing
it), include the Unit Price as a column in it's Rowsource. In the
AfterUpdate event use..

Me![pricebox]=me![combo].Column(x)

(replace control names and column number as needed)

.