Subform Data Display

[all4jcvette]

I have a data entry form, that when a user hit's the "Add Record" button, the data is populated into a temp table, and then the subform is requeried showing the user the record that they entered. On the main form, I have the item numbers hidden and the item description shown so the users can select the item by description. That actual data that is recorded in the table though is the item number. I want to mirror this in the subform. When they hit the add button, I want the item description to be visible in the subform, not the item number even though the item number is the actual record that is written to the table. I can't figure out how to do this. Think of this like an orders table where you are linking mutilple tables and keys from different tables into this one.

Right now, in the subform, the user sees the item number, which is useless to the user.

 

[vbaInet]

Why the use of a temp table? See this discussion, especially post #11

http://www.access-programmers.co.uk/forums/showthread.php?t=217021