Passing parameter to DataGrid object

[victor10]

Hi everybody, I work with VB 6.0 and Access 97.

On my form I have textbox txtCompany, DataGrid1 and ADO.
ADO is connected to database and for RecordSource I have
SELECT * FROM Customer. So it displays all rows.
I want to display only customers for the company that typed in textbox.

Should I have sql in RecordSource as 'SELECT * FROM Customer where Company = ?' and call Datagrid at runtime.

Please help, never done it before.
Thank you.

 

[vbvictim]

try making your sql say
"select * from " _
& "customer where company_name ='" _
txtCompany.text & "'"