Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
List box 2 based on list box 1
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00253199
Message ID:
00253588
Views:
17
>Jim, to follow up on your idea yesterday (I have a similar problem I'm trying to solve populating a listbox2 from a combobox1),
>
>I'm using the following code:
>
>combobox1 valid:
>
>cSearchValue = left(this.value,4)
>thisform.listbox2.requery(cSearchValue) (passing the combobox value to the requery method)
>
>---------------------------------------------
>
>listbox2 requery:
>Lparameters lcParmForView
>Requery("GetNumberDnis")
>
>rowsource = GetNumber (name of view)
>rowsourcetype = 2 - alias
>
Joe,

First the Requery addresses GetNumberDNIS and NOT GetNumber, second the alias name must be in quotes for assignment to the rowsource, os I think you need to change;

rowsource = GetNumber (name of view)

to

rowsource = "GetNumberDNIS"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform