Hints and tips home » Access hints and tips » Copy a Previous Record's Values to a New Record

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

Added by Carlos on 25th October 2006

More Access hints and tips, like:

• Create a custom Close button on a Form
• add date to a field
• Space marks