Arthur Fuller
artful at rogers.com
Tue Jan 17 11:30:13 CST 2006
I have a form in an inherited app that posits two ways to search: a) you can select from several listboxes, each cascading to the child until finally you end up with an invoice number; b) if you know the invoice number, you can select this option and go directly to the invoice. I enclosed the options in an option frame whose code disables the choice you didn't make and enables the choice you did make. (i.e. you can then enter the values for a) or b)). This all works, but what I want to happen is that if you choose search method b) then the listboxes in choice a) all move to the corresponding locations within the listbox. I am assigning the values correctly, according to debug.print anyway, but the listboxes are not rotating to the corresponding items. In my code I assign the values obtained via selection b) and then requery the listboxes but they do not move to the selected item. I want the current value to appear topmost on the listbox. What am I doing wrong or not doing? TIA, Arthur, Son of Uther Pendragon, Defeater of the Saxons, Lord Over Alllll England, and King of the Dorks