A two-field value list still only inserts a single value (always from the first field, regardless of any other settings). Consequently, that field holds an ID and nothing else (and a good thing, too.
But you are probably storing that ID for a reason – namely, to have a relationship to another table**. So, use that relationship by reading the desired name (or any other) field from the related record that the ID links to.
**If you don't have a relationship and till now only relied on a popup control's ability to resolve the first field of a value list to its associated second field, those innocent days are over …
Create a relationship using that key, then you can read the related value programmatically.
- Ok, I understand now that the first field being the only value actually being stored from the specify value list dialog. (I need to start reading all those dialog box text.)
- It took me a while to understand you are getting at; I changed the field name to the field name in the parent table where the parent key came from.
- It works now. Thanks