>I have a couple of fields in a table based on options in a listbox. The controls work, in that they allow me to make a choice and the choice is stored. However, if we move away from the record and return to it, the listbox does not show the value of the variable to which it is bound using the ControlSource Property. All other fields update as they should, so 'thisform.refresh' works for them. And the 'watch window' shows that the field value is indeed as I selected. But the listbox display aint showing it…
Harry,
The lsitboxes value and the value in the field for tis controlsource must be an exact match including length. If they are not you are better not using controlsource and writing the code to update the field in the lists Valid and in the list's Refresh write the code to synchronize the field with the list by setting the list's value property to make a match in the list items.