That's it exactly. I am trying to understand exactly how to do this. I will
re-read it a couple of times before I throw my hands up and ask for more help.


Many thank to you both.

Best,
Scott

Jeanette Cunningham wrote:
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

Greetings:

[quoted text clipped - 21 lines]
Thanks,
Scott

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