table population from combo box form

[zestril5]

I have 2 tables One is “Item master list” which contains Vname, Item no and description.
The other table is “Item Purchases” and the fields are Vname, Item no, description, date, qty and price.

I created a form using all the fields in “Item Purchases” except the item no. For this I created a combo box sourced from the “Item master list” using all three fields. The user is to choose from the drop down the unique item no. then the Vname and description are filled in using control source [combo21].column(2) and [combo21].column(3) respectively.

So far all works well, but the “Item Purchases” table does not receive the Vname or description values from the form, only the item no.

Obviously I’m not using the right technique here. Can someone point me in the right direction please?

 

[Fekri]

Hi,

I think it's better to do this way,
create to text box for vname and description and make their control source as the fields name in Item Purchases.
then put these expression [combo21].column(2) & [combo21].column(3) in each text box as default value.
should work.

good luck