>>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.

I guess I could set the rowsource to an alias and use a different one of each of the two combo boxes.

The array option seems to be the smoothest if I can get it to work.

I have a key word text field where the user can enter a word that must appear in either the long description in the file if one of the all radio buttons is selected or in the short description field if one of the most used buttons is selected. So in the record source I must change the fields return from the file between ID+short description or ID+long description. The filter ranges between MostUsed = .t. and KeyWord $ description This filter varies based on which radio button is selected and whether there is a key word value set.

It seems relatively easy to manage all this in select statements building the array. I can get the values I want in the array. My problem is getting the array to show in the dropdown.