I appreciate your help Eric, but I think Ive done a poor job of explaining myself. Let me try this again from the start.
I have an Access database with 2 tables. Table 1 is the primary table and stores the users entries. Table 2 is propulated with data I have entered (a lengthy descriptive field) The end user does not have access to table 2. Each table has an auto-generated record number field. When the user is adding or editing a record for table 1, they have a combo list box (populated by the contents of table 2), from which to choose an entry. The auto-generated record number is stored in table 1, to identify the record in table 2 for that entry. What I am having trouble with, is when the user goes to edit a record, I am trying to display the correct entry from table 2.


Any suggestions?