>Yes, reuery() for listbox is after SELECT.
>( SELECTs ... are in DO CASE loop - and look like this:
>
>
>case thisform.C1.value==.T. .and. thisform.C2.value==.T. .and.thisform.C3.value == .F. .and. thisform.C4.value== .T.
> *
> SELECT NAZIV from OBJEKT WHERE alltrim(POGON) == thisform._C1 .and. ;
> TIP == thisform._C2 .and. ;
> GRUPA == thisform._C4 ;
> order by NAZIV into ARRAY THISFORM.IZABERI
>
>( thisfrom._Cn keeps last value from combobox )
Have you tried binding the value of the combo to a form property?
Then, in the interactive change of the combo:
This.value = this.List( This.ListIndex)
Thisform.cn = This.value
And use thiform.cn in your select. Thus, as you change the combo selection, you've always got an up-to-date value for the SQL.
HTH
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.