How to populate 1 field based on contents of another?

[OrlandoG7]

Hi. Thanks for looking at this question.
I have 1 table with 2 fields [Article] and [Cube]. There is a form for this table. When I select an article in the form I want to automatically populate the form's [cube] field.

The table has articles such as:
ARTICLE CUBE
TV 3
Bed 10
Chair 5

Any sugestions are much appreciated. Orlando

 

[mac318]

If I'm reading your need correctly, a combo box would do the trick for you. The combo box would contain the two fields. The first field would hold the article and the second field would hold the cube. When someone types in the article, the cube would be shown beside it.

mac

 

[OrlandoG7]

Thanks Mac. I finally found a way to do this and as u suggested, it involves a combo box with an "after update" event that populates the second field.