-
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
-
You need to use an SQL query on your database something to the effect of ....
Code:
"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.
