TIP: How to fill down in Access tables, queries and forms

[isladogs]

As is widely known Excel has a very useful autofill feature.

AFAIK much 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:
https://support.office.com/en-gb/article/keyboard-shortcuts-for-access-70a673e4-4f7b-4300-b8e5-3320fa6606e2
I'd be amazed if anyone here knows & uses all of them ....!

 

[RuralGuy]

Thanks for the tip Colin.

 

[Uncle Gizmo]

I demonstrate a method of doing similar within a subform with VBA code:- http://www.niftyaccess.com/subform-record-duplicator/ - there's a paid for and free option...

 

[isladogs]

UPDATE 11/11/2019:
If you need to duplicate the contents of several fields at once, you may be interested in an example application by AWF member APR Pillai.

He uses the Tag property to Duplicate Multiple Fields in a record to the next record with conditional formatting

This is part of his Learn MS Access Tips & Tricks website which I recommend strongly.