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
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