For some reason when I am trying to add records to the junction table, I only add 1 record per document where Ricks code adds each appropriate word as it should.
I don't understand why me code doesn't work?

HELP

Mike Albert

I just looked at the AddToIndex Sub in the stock database. Yours is different.

Is it different than my copy of Ricks code?

I guess the problem is the code you looked at is form the end of lesson 6. I'm trying to follow along and I'm only at lesson 4. So it will be different. The top image is what Rick's done, The bottom is mine. I don't see any substantial difference. Just thought you could help.

Thanks.
Mike

Michael I don't know if this would be causing the problem or not, but I noticed in the filter string you added () to the characters being filtered, and I'm wondering if maybe that could be the issue.

Thank you Sandra for your comment.
In this case the () are required because I'm building an index for VBA code so I need it. Good thought though.
With some tinkering (not sure what I even did not) but got the code to work correcty.

Thanks again.  Mike