"auto fill" of field when typing into table

[Guest]

I am trying to figure out how to set a field in my table to "auto fill"
based on what was typed in this field previously. Just like Excel, I want
this field to recognize the first one or two letters you are typing in the
field, and then auto fill it, with what was typed in it previously.

In my table, I have several fields where I am going to be typing in the same
word or date over and over. I don't want to use a combo box to "pick" the
information out of the box, because that is too slow. I want to be able to
type in one or two letters, auto fill and then tab to the next field.

Help! This is probably so simple, and I know that Access has this ability,
bu I have yet to find it.

 

[Guest]

Russell,

If you are in a table you can use the CTRL+' key sequence in any field to
copy the value in the previous record. I don't think that the previous value
can be defaulted as there are no coding events available whilst entering in
table view.