As is widely known Excel has a very useful autofill feature.
Less well known is the Access 'equivalent' which allows you to copy the value from the same field in the previous record to the current record
To do so use the keyboard shortcut Ctrl+' (apostrophe)
This works both to fill an empty field or to replace an existing value
It works in tables, queries & continuous / datasheet forms
Of course you can also do this using copy & paste but that needs more clicks ...
A complete(?) list of keyboard shortcuts can be found here: