[Gambas-user] Datasource filter

[Cyro Corte Real Filho]

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.