Adodc and datagrid

hi,
i have a table in ms access named "students" and i want to fill a datagrid with an sql query that retrieves data from this table.
-----------------------------------
Adodc1.RecordSource = "Select studid,schools,depart From students where studid =" & Text6.Text
Set DataGrid1.DataSource = Adodc1
-----------------------------------
I use this code but on the datagrid i see the 3 fields for all the records not only the records that the id of the student is equal to text6.

Any suggestions?

Is text6.text a number or string? If it is a string then you need...

...Where studid = '(singletick)" & Text6.text & "'(singletick)"

Is text6.text a number or string? If it is a string then you need...

...Where studid = '(singletick)" & Text6.text & "'(singletick)"

I tried this too ("Select studid,schools,depart From students
where studid =' " & Text6.Text &" '

but i have the same results.
Is there another way to fill the datagrid?

I tried this too ("Select studid,schools,depart From students
where studid =' " & Text6.Text &" '

but i have the same results.
Is there another way to fill the datagrid?

You have to use .Refresh
Adodc1.RecordSource = "Select studid,schools,depart From students where studid =" & Text6.Text
Adodc1.refresh
Set DataGrid1.DataSource = Adodc1