>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.
Why don't you use the rowsource table AGAIn under a different alias and so have each of the combos with a separate rowsource? In case of arrays, keep two arrays.