This method was actually very efficient for listing information on the form that I don't need to save. Since the data is already recorded in another table, I would NOT be recording redundant data.
I actually will use it more often now. Thanks for pointing me in this direction.
For those that might be looking this up, here is the solution that came up.
I already have a combobox on my datagrid with three field results in it.
EG:
Code:
'Populate your combo box with data.
myComboBox = SELECT ID_custtable, cust_number, cust_fullname from customers
Now, if you don't want to store the data in the form, and only need it to be shown for ease of use. For example, if you enter the customer number you will probably want the customer's full name to display so you can show your user that the correct member has been selected.
Create a textbox, we'll name it creatively - fullname
Then in the ControlSource box enter
Code:
=ComboBoxName.Column(X)
Use the name of the ComboBox you're looking up the information from.
The X is the Column of data you want to display.
Using the current example, if I used Column(2) it will display the fullname. When counting the columns, remember that the columns start at ZERO not one. So it's 0,1,2
Hope this helps someone else.