Others

How to Add Existing Query Fields to a Microsoft Access Form

Amos Gikunda Oct 12, 2026 868 views

Question details

The user wants to know how to display and drag fields from an underlying query onto an Access form, as well as how to calculate aggregate totals like sums and averages.

How to Add Existing Query Fields to a Microsoft Access Form

Product: Microsoft Access
Device & OS: not provided
Scenario: Customizing a form layout by adding new data fields from a query and performing mathematical calculations on those fields.
Observed behavior: Needs to add bound controls from the record source and unbound text boxes for calculations without automatically adding unwanted labels.

Before you start

Ensure your Microsoft Access form's Record Source property is correctly bound to the specific table or query that contains the fields you wish to use.

Solution 1Recommended

Add Existing Fields using the Field List

Use the Field List pane in Design View to drag and drop available bound controls onto your Access form.

By default, when you drag a field from the Field List, Access will create a bound text box control along with an attached label displaying the field's name.

Open Design View

Right-click your form in the Navigation Pane on the left and select 'Design View'.

Access Form Design Tab

Navigate to the 'Form Design' tab located on the top ribbon.

Open the Field List

Click the 'Add Existing Fields' button to display the Field List pane, which shows all fields available from the form's record source.

Drag Fields to the Form

Click and hold the required field from the list, then drag it onto the desired location on the form grid.

Add Existing Fields using the Field List

Bound vs Unbound Controls: Strictly speaking, forms contain controls, not fields. When you use the Field List, you are creating a control that is 'bound' to that specific field in your query.

Solution 2

Calculate Totals (Sum, Count, Average) on a Form

Create aggregate calculations by adding an unbound text box and entering an expression in its Control Source.

Solution 3

Prevent Access from Adding Attached Labels

Modify the default form template settings if you prefer to add only the data control without its accompanying label.

Free Microsoft Office alternative

Enhance Your Productivity with WPS Office

While Microsoft Access is powerful for advanced database management, WPS Office provides a free, lightweight, and comprehensive suite for your daily document, spreadsheet, and presentation needs. It is fully compatible with Microsoft Office formats, allowing for a seamless transition without a subscription.

Fully compatible with Microsoft Word, Excel, and PowerPoint filesFree and lightweight suite, using minimal system resourcesFamiliar user interface requiring no learning curveBuilt-in PDF editing, conversion tools, and advanced spreadsheet data analysis features

microsoft office alternative - wps office

Frequently Asked Questions

Why are the fields in my query not showing up in the Field List pane?

This happens if the form's Record Source is not set correctly. Open the Property Sheet (F4), go to the Data tab, and ensure that the Record Source dropdown has the correct query or table selected.

Can I add a field by using the control toolbox instead of the Field List?

Yes. You can click a control type (like a Text Box or Combo Box) from the Controls group in the ribbon, place it on the form, and then manually select its Control Source in the Property Sheet to bind it to a specific field.

When should I use a subform instead of adding fields from a multi-table query?

If your form requires data from multiple related tables, especially in a one-to-many relationship, inserting a subform is more stable and manageable than attempting to build a complex multi-table query as the main form's record source.

Office Quick Solutions