Store Historical Customer Address for Accuracy Part 2

In this Microsoft Access tutorial I will show you how to set default values in forms when copying customer address data into new orders, avoid common #Name errors, and handle situations where opening a form can create unwanted blank records. You will also learn tricks for updating default values on multiple fields, customizing buttons to add or view orders, and making sure your forms work smoothly whether opened from the customer form or a main menu. This is part 2.

Prerequisites

• Storing Duplicate Data, Part 1

Recommended Courses

• Access Developer Courses

Up Next

• Storing Duplicate Data, Part 3

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Merch Store - Get your swag here! Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, Storing Duplicate Data, default value property, pound name error, set default value with VBA, copying customer address to orders, open form to new record, avoid blank records, button event code, address city state zip country fields, do command openform, build event, add order button, main menu button, replace embedded macro, new record issue, order form from customer form, automate order address, form controls tricks