MSFlexgrid manipulation

[BRENDON]

Hi

I am working on a project using a msflexgrid.

I have managed to run the program and get it to show the records contained in an Access database and everything is fine.

However, now I want to make the grid display only the records in the database that contain a certain figure or text in a field.

Say for instance I do a text or input box and make the grid display only the records in the database that contains what ever is put into the input box.

What code do i use to tell the grid to display only these records and do the correct filtering?

Any ideas? Anyone?

Cheers

Brendon

[YoungBuck]

You need to use an SQL query on your database something to the effect of ....


"SELECT * FROM Table WHERE Field = 'Jon';"


and then just display the records the same as you have been doing. If you can supply some code I could give a clearer explanation.