How to Auto Fill in Access

When you enter data in a form in Access, you can automatically auto fill certain fields to make the data entry faster. The Auto Fill feature in Access allows you to automatically fill in fields based upon the previous record or information already entered in your database. For instance, if you enter a student's name, their course list will automatically fill in. Auto fill a single field in Access or do it with multiple fields as needed. There is no limit to the number of fields you can auto fill on a form in an Access database.

Open an Access database, select "Queries" from the main database window and select "New."

Choose "Design View" and select the table or tables containing the fields you want to auto fill in your Access form.

Add the fields from each table that you want to base your auto fill on. For instance, if you want to auto fill an address based upon the person entered into the form, add the person's name and the person's address fields.

Create a relationship between the tables if you're adding multiple tables,
For instance, if you have a person's name and address in one table and you also want to fill in the person's job title and employer's address, you would create a relationship between the person's name in each table. Drag the name from one table to the corresponding name field in the second table to create the relationship. Save your query.

Select "Forms" from the main database window. Choose "New" and select "Form Wizard."

Select the query you just created from the drop-down list to base your form on.

Add the fields you want to include. You can edit the form again later in Design View.

Choose to view your form once you've created it.

Enter your new record information into your first field. The rest of the fields should populate automatically if the first field already exists in your table. For instance, if you entered the name of a person who already exists in your table, all information about the person would appear in your form. If the person doesn't exist, no fields will be populated.

Most recent

×