link a combo box to another text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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).
 
Thanks Ken. I kind of figure it out. I was trying to cancel my posting, i
guess I can't.
Thanks anyway.
 
Back
Top