>>>I was wondering if anyone has worked with a parameterized view in a combobox before and if they have how do I update the listbox when my variable has changed. I've tried THISFORM.ComboX.requery() with no success. Any suggestions would be appreciated.
>>>
>>>Mark A. Struck
>>
>>Firstly, you have to =Requery() the view and only then combo.
>
>Ed,
>
>I think there is more to it in this particular case because the combo is based on a parameterized view, so he'll have to put some code in the requery to accept a parameter. Something like this (pseudo code)
>code for REQUERY()
>
>LPARAMETERS lvp
>
>
= lvp
>SELECT Combo box view
>REQUERY()
>SELECT form view
>
>
>José
Surely, if it's parameterized view then parameter should be supplied.
Edward Pikman
Independent Consultant