Ms Access Populate Field Based On Another Field (Resolved)

This document provides helpful and actionable information on how to populate a field in Microsoft Access based on the value of an existing field.

Prerequisites

Open your database in Microsoft Access.
Highlight the existing field you want to pull data from.
Click on the “Create” tab and then select the “Query Design” option.
Add the existing field to the query design window.
Create a new field in the query design window.
Put a check mark into the “Show” field from the fields section of the Properties window.
Select the Junction Table option from the query design window.
Configure the criteria for the junction field by comparing the existing field with the new field.
Run the query and then click on the “View” option in the ribbon to confirm that the query ran correctly.
Save the query.
Create a form or report by modifying the query in the design view.
Put a check mark in the “Display” option in the properties window.
Set the text box’s bound column to the newly created field.
Run the form or report.

A1. You need to have your existing field and a new field in order to populate a field in Microsoft Access.

A2. You can create a new field in MS Access by going to the “Create” tab and then selecting the “Query Design” option.

A3. You can configure criteria for a junction field by comparing the existing field with the new field using the query design window.

A4. You can confirm that your query has run successfully by clicking on the “View” option in the ribbon.

A5. You can set the text box’s bound column by selecting the newly created field in the Properties window.