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