Data Entry Form design question

[sysadmin101]

My Sub-form in layout mode has a combo-box for the Product ID.
How can I display the other fields from the Products Table for the convenience of the user as he is entering more lines? i.e. user selects code for product, which then appears in the field, but the combo box only retrieves one value from the Products record, and to add more selections for the same information breaks the rules of normalisation etc.
I would like the lines to display dynamically as the user is entering them.
I know how to add a Form refresh macro, the problem is I don't know how to display these other fields eg. as sql statements in Control records?
The orders main form has the Current PO Number value.
Thanks in advance for any tips or suggestions

 

[John Big Booty]

You can use unbound text boxes to display the additional information. IN those text boxes use the following as the Control Source;

=[YourComboName].Column([B][COLOR="Red"]x[/COLOR][/B])

Where x is the number of the column of the combo that holds the additional data you wish to display. Remember that the columns in a combo, or listbox, are numbered from Zero up (the first column {zero} is often bound and hidden). These columns need not be visible.