View Single Post
  #3  
Old May 21st, 2010, 10:19 PM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default show 2nd field when combo box choice is made

In the after update event for the combo, you can use code to copy the price
from a hidden column of the combo to the price textbox.

Me.PriceTextboxName = Me.ComboName.Column(2)

For a sample database that shows this in action go to

http://allenbrowne.com/TechniqueEnterCalcText.html

Don't be put off by the title which is about entering text in calculated
controls, this database does show how to get the price into the orders
table.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Scott_Brasted via AccessMonster.com" u56211@uwe wrote in message
news:a85a0a19e7f37@uwe...
Greetings:

I have a db for clients and their purchases. In my attempt to further
normalize my tables, I have created a new table to list the products
clients
can purchase. So now i have 3 tables. One has the client info, the 2nd has
the individual orders (ID, client foreign key, product (stores combo box
info)
, order date, quantity ordered and a price number field to hold the info
this
question is about) and the 3rd has the list of products and the price of
each
product.

I have a form to enter the client info and a subform to enter each
client's
order info. The order subform has a combo box to choose the product
ordered.
When I choose the product,I would like the price from the product table to
go
into a field in the subform and be recored in the order table. Is this
possible?

Thanks,
Scott

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1