goilaswati
Programmer
sir
i have a form in which i have a text box & a datagrid. the datagrid contains feilds such as code,name etc. the text box is made for entering code numbers. my purpose is that whenever i enter any code number in the text box, the datagrid should display codes only like those entered in the text box. i have done it this way:
SQL = "select * from M_EMPLOYEE where NAME like '" & Me.txt_empcode.Text & "*' "
Me.Adodc1.recordsource = sql
Me.Adodc1.Refresh
Me.DataGrid1.Refresh
Me.Adodc1.Recordset.Requery
but this is not working , please help
i have a form in which i have a text box & a datagrid. the datagrid contains feilds such as code,name etc. the text box is made for entering code numbers. my purpose is that whenever i enter any code number in the text box, the datagrid should display codes only like those entered in the text box. i have done it this way:
SQL = "select * from M_EMPLOYEE where NAME like '" & Me.txt_empcode.Text & "*' "
Me.Adodc1.recordsource = sql
Me.Adodc1.Refresh
Me.DataGrid1.Refresh
Me.Adodc1.Recordset.Requery
but this is not working , please help