I really appreciate your help, but I haven't really changed my question - just the code, as obviously I'm not clear on how to achieve my goal, which is:
1) to have a listbox display the name that corresponds to a stored number and, in the case of a null value, display a blank entry;and
2) to changed the value of the bound field to correspond to the listbox entry selected by the user.
The new code gets me much closer, but here's the remaining problem. I'm using a split form. As I cycle through the records, if the first record contains a null for PHA, the listbox displays a blank, as it should, But once I display a record with a non-null value for PHA, any subsequent records containing a null for PHA display the name that corresponds to the value of the last record with a non-null value. How do I correct this? Thanks again for your help!!!!