> I want to fiter data on DBGrid. I  have this code in click() event of
> cmdbutton on the same form where dbgrid is located :

> Private Sub cmdfilter_click()
> Data1.RecordSource "Select* from [modems] Where [type_modem]="ASMi 450"
> Order by [type_modem]"
> End Sub

> It doesn't work. I don't know why.

> ....But when I have this SQL command written in RecordSource property of
> DataControl (in time of creating of application), after start the DBGrid
> show me what I want ( Just the records which have the "ASMi 450" value in
> the "type_modem" - column of recordset.

> My question is : Why doesn't it work under the click() procedure of button
?

> Thank u for your answers !!!

> MarianF