If a new record will be similar to the previous one , you may wish to automatically fill text boxes with that data for the user to edit. Use a form's BeforeInsert event to achieve this result in Access. Open the form in Design View. In the Properties Box, select the BeforeInsert event, and type the left square bracket.
Access responds by opening the code window.
Save the form. In the Database window, select the Modules tab and choose New . Select Case Err Case 2448 'Cannot assign a value Debug. Next Case 3265 'Name not found in this collection.