I’m having an interesting problem that I can not seem to find the pattern. I have a form that has two combo boxes that are set as drop down lists. On the same form there is a radio button with 4 buttons.

Both combo boxes have the same record source so that I can select two distinct values form the table. In this case a primary and secondary diagnosis.

The radio buttons set the order of the items in the dropdown to either the description of the diagnosis or the numerical code of the diagnosis, and whether the list is the full list or a filtered list of the most used.

Numeric all
Numeric Most Used
Alpha All
Alpha Most Used.

Now the problem. If is select a radio button, I get the order and filter set properly and can select the appropriate diagnosis. If after selecting the diagnosis, I click another radio button, the diagnosis code may or may not disappear. If I click that same radio button again, it may or may not reappear. I still can seem to find the pattern. It does seem to be related to having a value in the second of the combo boxes.

I guess my questions is what are the considerations to having a value in a combo box and then changing the RowSsource and order?