Fill in field automaticly after select item from combo box

[JiTS]

Hi,

Problemsituation (see attachment):
I have a subform to fill in the input and output items in our company. The fields you see will be saved in the table tblStock.

Description of the fields:
[IN]
ITEM -> combo box with item names from table tblItems
WEIGHT -> weight of the item
# -> the quantity items that goes in

[OUT]
ITEM -> combo box with item names from table tblItems
WEIGHT -> weight of the item
# -> the quantity items that goes out


[tblItems]
ITEM -> item name
WEIGHT -> standard weight


Problem:
Each item does have a standard weight and it's saved in the table tblItems. I am able to get the item name from the table (see field ITEM).

Now, I want that the field WEIGHT will be fill in automaticly when I select an item... that means the weight of the item must picked from the table tblItems.

Do I have to build a query for this or is there a shorter solution?

Please help...


Thanks,
JiTS

 

[spacepro]

Use the 'Dlookup' Function in Access.

Do a search for DLOOKUP for more help on syntax.

Andy