Displaying Data from Query on Form

[Larry in TN]

I'm new to Access but have been using Excel since 1990. I'm working on a "simple" project as a way to learn Access.



I have Access 2016 for Dummies and haven't been able to find the answer to this question in the book. (So far, it doesn't seem that helpful as a reference for looking stuff up)

I have a Table with my data and a Query that calculates some sums from the data. How do I display the results of the Query in controls on a Form?

If tried using a Text Box with Control Source "=[qryQuery]![FieldName]" but the result is "#Name?".

I can't figure out the correct syntax for references the Query data (or I've left something else out somewhere?).

Thanks,

Larry

[John_G]

All you need to do is make the query the record source for the form. All fields from the query are then available as sources for the form controls.

[ItsMe]

How do I display the results of the Query in controls on a Form?

Under the Design Tab within the Ribbon, create a new form via "Form Design". In the Property Sheet (by default it should be to the left), you can assign values to the Record Source of the From. The Recorsource property is located under the Data tab within the Property Sheet.

Use the pulldown to select your Query Object's name. With your query as the Form's recordsource, you can add controls to your form's design surface that are bound to the Query. Use the "Add Existing Fields" tool under the Design Tab from within the Ribbon to add bound controls to your form.

If tried using a Text Box with Control Source "=[qryQuery]![FieldName]" but the result is "#Name?".

Practice with bound controls and then you can substitute an expression for a Recordsource's field name.

[Larry in TN]

Thanks for the replies. I don't fully understand how that'll work out but I think you have me pointed in the right direction! I'll give it a try over the next day or two and see how far I get.

Thanks again!