I am entering notes into a memo field on a form. Beneath the field, I'd like to be able to enter keywords. At the end of the year, I'd hope to use a query-based report to make an index of the notes, but I'd like to use the same keywords as much as possible to minimize the size (and so I don't end up with separate entries for "adverse possession" and "Adverse poss." )

At the moment, I have two tables, the main entry table and an id-related keyword list. It is the keyword field on the subform that I'd like to have a memory. I want the field to act similar to an MS Excel cell. If I've previously typed the word "example", when I type "E" in a subsequent filed, the cell prompts for example. If I enter "excellent", then in the next cell that I type "exc" or "exa" the appropriate word is prompted. Any suggestions? Thanks.

Jeff

Don't Allow Direct Typing into the Keyword field. Use a list box to select your Keywords and have it append them to the Keyword Field.