transferring filtered records to MS Word

any suggestion how can i transfer filtered records to MS Word. Whenever I use the AppWord.Documents.Add it only adds the last record

Which type record do u use?If u use ms access,u can use ado object to read the recordset and use office word object to write these recordsets to the word document with youre custom format...

I'm using MS Access, I tried to run a test on how the program works, the problem in this test is this

......
AppWord.Documents.Add
AppWord.ActiveDocuments.Content.Text="Hello"
AppWord.ActiveDocuments.Content.Text="This is a test"

.....

the problem is instead of printing both 'hello' and 'this is a test' it only prints the latter

anyway so that i can print those two

Chang your code like it:
AppWord.ActiveDocuments.Content.Text="Hello"
AppWord.ActiveDocuments.Content.Text=AppWord.ActiveDocuments.Content.Text & vbcrlf & "This is a test"

thanks cleverpig!