>I have two comboboxes on a search form along with the listbox that displays search results. One combobox works great, the other does not.
>
>One combobox has a RowSource of Fields the other combobox has a RowSource of Array. The Fields-based combobox works perfectly. The Array based combobox sometimes shows the correct list in the listbox, but sometimes it shows the correct list for a split second and then the list disappears and a solid gray color covers up the listbox.
>
>Both comboboxes use SET FILTER TO to populate the listbox based upon the choice made in the combobox. Both comboboxes have similar code in their Valid Events. The last line in each Valid Event is THISFORM.MyList.Requery. I don't see anything wrong with the array-based combobox.
>
>I am still working on it.
>
>Any ideas? Thanks.
What is rowsource for listbox? What it has to do with SET FILTER? Can you use a SQL for ListBox RowSource?
If it's not broken, fix it until it is.
My Blog