Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requery()
Message
From
10/03/1999 14:16:42
 
 
To
10/03/1999 14:13:11
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00196011
Message ID:
00196013
Views:
32
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform