Hi,

I developed a form in which the elements of a combo box are fed from a table with a list of state codes. The problem is that when I choose a state code and then run a macro linked to the form, when I return to the table of state codes, the state that I choose to run replaces the first state on the list (namely, AK for Alaska).

So in other words, this is what the state code table looks like initially:

AK
AL
AR
AZ
CA
etc.

Say I run FL. Then it looks like this:

FL
AL
AR
AZ
CA
etc.

Alaska is no longer on the list.

Does anyone know how to fix this? I figure there is some kind of property I need to change, but I am not sure what.

Thanks.