Hi,
Is there a way to get the combobox.displayvalue (a character value)to show the combobox.value despite the combobox.controlsource value is not spelt the same?
For example: combobox.controlsource is set to tableA.field1. The rowsource is set to tableB.field1. If a name in tableA.field1 is spelt like "Ann Oswald" and in tableB.field1 spelt like "Ann OSWALD" the combobox.displayvalue shows "" and the combobox.value is "Ann OSWALD", i.e. the combo display is blank. If the name is spelt the same way in both tables, ie tableA.field1=tableB.field1="Ann Oswald" the combobox.displayvalue="Ann Oswald"