By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,484 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

auto update form value

P: n/a
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
Feb 15 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Feb 15, 6:08 pm, "Phil" <no-...@home.comwrote:
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)

Feb 16 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.