link a combo box to another text box

[Guest]

I have 2 tables: MAINTABLE & LOOKUP (no relationships)

MAINTABLE: RecordID, Item, ItemPrice, Quantity, SubTotal
LOOKUP table: ItemID, ItemName, Price

I also created a LOOKUPQuery based on the LOOKUP table.
I created MAINForm based on the MAIN table. On this form
I have the "Item" as a combo box that looks up the value from the
LOOKUPQuery. I want the "ItemPrice" to change based on the
"ItemName" I selected from the combo box. In other words, the "ItemPrice"
should correspond to the "ItemName" on the LOOKUPQuery.

The entries will be all saved on the MAINTABLE.

How can I go about doing this? Do I need to link the two tables?
I don't see any reason why I need to link these two tables. Please
explain. I'll appreciate any ideas. Thanks.

Feel free to email me directly at (e-mail address removed).

 

[Ken Snell [MVP]]

This article tells you how to show the other columns of a combo box in
textboxes:
http://www.mvps.org/access/forms/frm0058.htm

 

[Guest]

Thanks Ken. I kind of figure it out. I was trying to cancel my posting, i
guess I can't.
Thanks anyway.