Unbound combo doesn't show chosen value

[Kristian]

In a multiuser application with unbound forms some - not
all - combo boxes seems empty although they contain a
value.
The code can read the value so it's there, but the
control looks empty. When entering the control the
insertion point shows the end of the chosen entry, i.e.
if I choose a five letter alternativ the insertion point
will blink after position five.
I've tried with me.refresh and such but it doesn't help.
Any ideas?
TiA,
Kristian

 

[Jeremiah Ellison]

In a multiuser application with unbound forms some - not
all - combo boxes seems empty although they contain a
value.
The code can read the value so it's there, but the
control looks empty. When entering the control the
insertion point shows the end of the chosen entry, i.e.
if I choose a five letter alternativ the insertion point
will blink after position five.
I've tried with me.refresh and such but it doesn't help.
Any ideas?
TiA,
Kristian

I've encountered that problem before, it's been a while though so I'll try my best to remember it but please be patient. I
believe it comes from using a combo box where the column displayed in the text entry part is not the bound column. The data
displayed is not actually saved in the combo box and so when the RowSource of the combo box is changed to eliminate rows that
are selected, it sort of "forgets" the values. The solution I used is simply having a full, unfiltered RowSource in which all
possible selected values are included. Then on the GotFocus event of the combo box limit the RowSource and then on the
LostFocus event remove that limit again so that you're only limiting the rows as they are using the combo box to enter data.

Jeremiah Ellison
Ellison Enterprises - Your One Stop IT Experts