>Using a ComboBox where the Control source is cust.refby and the rowsource is a table named refertbl.refby
>
>The customer has the capability to add new or delete records from the rowsource table.
>
>For example: A field that was in the rowsource was "Fall 08 Sample". It was no longer needed so it was deleted. Earlier, though, it had been selected and exists in the cust.refby field.
>
>Now, when the cust table screen is opened, the ComboBox displays a blank, even though the cust.refby record still contains "Fall 08 Sample"
>
>The customer sees this and thinks the cust.refby field is blank, when it's not.
>
>Is there a way around this action?
Are you using DropDown combo? Did you try switching the type of the combobox? You can also try to set DisplayValue of the combobox to the value in the table.
If it's not broken, fix it until it is.
My Blog