>In some of my new forms I'm using DropDown List boxes that are controlled by other List boxes: with box 1 user selects table, based upon that selection a SQL statement populates Box 2 and 3, with box 2 user selects index and/or with box 3 user selects filter, etc. I populate arrays with an SQL statement but boxes 2 and 3 don't appear to populate when they should. My reading tells me I should be using Requery() but dosen't tell me in which property to place it. Any suggestions? TIA.
>
>Regards,
>
>Paige
When you change combo.rowsource dynamically (e.g. in your case repopulating arrays, these are rowsources if i understood you correctly) you should fire Combo.Requery method after each change, i.e. right after array got repopulated (SELECT-SQL).
Edward Pikman
Independent Consultant