For smart people: add a field in a subform

[tigreeuropeo]

Hi, everyone!!.
I have a form with a subform.

With this form the users type in orders, and in the subform they type the articles they buy, identified by a reference.

I have 3 tables related: orders, order items and articles.
I didn't put the field "description" from the table articles when I created the form and the subform, and now I have a lot of code written in VB, so I can't start all over again.

I want the description to appear when the user types the reference of the article. How do I do that without starting again with the form?.

Thanks in advance.

 

[Sylvialn]

You could create a display text box, that when they type in the article, it pops up the description in this field somewhere else (either on the form itself or the subform) - by making it just a display box (therefore no data is saved - it just flashed a descritpion) - and it can changed on every OnChange or Update (depending on whethere or not they are typing in data or scrolling through). Hope that helps alittle. "Try everything at least once."