[Gambas-user] Datasource filter

[Benoît Minisini]

> Hello,
> 
> I have two datacombos on my form, i need to select a display value on the
> first, and then when i click on the second datacombo, it to be filtered by
> the first datacombo value. I already tryed:
> 
> PUBLIC SUB DataCombo2_MouseDown()
> 
>   DataSource2.Filter = "cod = " & DataCombo1.Value
>   DataSource2.Refresh()
> 
> END
> 
> and also:
> 
> PUBLIC SUB DataCombo2_MouseDown()
> 
>   DataCombo2.Filter = "code_model = " & DataCombo1.Value
>   DataCombo2.Refresh()
> 
> END
> 
> But the filter does not work at all i still get all results from the
> datacombo2 table! What am i doing wrong?
> 
> Thanks.

First you must use the Click event, not the MouseDown event.

Anyway, the filter should work, but I can't say more without seeing the full 
source code, or at least a partial project that reproduces the bug.

Regards,

-- 
Benoît Minisini