>>I am using views so as to be able to use VFP or SQL Server. The view must be requeried using the new parameter value for agency (agency combo must be refreshed after parent requery), THEN the combobox must be requeried, and finally the combobox refreshed. Whew!
>>
>Cheryl,
>
>You can make your life a lot easier if you Requery() the view in the combo's Requery method. Then from anywhere else you just call the combo's requery method and it all happens.

Thanks for the response.

That's the way that made sense to me, and the way I did it at first. It just wasn't behaving properly. I have put the combobox requery in the object that requeries the view and now I just call the object's requery.

Seems to work.

Now, ocassionally, when the view is empty, and I refresh the combo or requery the combo, the DisplayValue gets set to CHR(12)! I don't know why. It causes my check for empty to fail. [This happens on a couple of comboboxes, not just the problem one.]

I had to restore DisplayValue to the empty string after the default Refresh().

Cheryl