keyword search of text in an access database

[araven]

hello

I am trying to construct some vb code to do a keyword search in some text in an access record and then loop to the next record until the end and every time it finds the keyword to record the primary key of that record value to for example a text file which i can then display in a datagrid with the full text

i am very greatful for any help you could give

regards

Adam Raven

 

[Paddyo]

Why dont you use an sql statment which searches the table with the Where statement using the LIKE function.

This would give you a recordset with the data you want.