>>The rowsource table is just a free table that's used as a lookup of choices for a single field in the cust table. These choices typically are changed on an annual basis.
>>
>>I just never noticed this happening in the past. Apparently, when you remove a field in the rowsource (lookup) table that value is no longer available for display, so it displays a blank. I would like to figure a way around this...to display the value in the cust.refby field instead.
>
>The ComboBox has an option that lets the user type anything... but also select from a list. Alas, I don't remember the exact property. Is it practical to enable that option?
I think it's Style property.
If it's not broken, fix it until it is.
My Blog