>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"