Displaying query results in form

[celito]

I built a query called qryStudCount, based on two tables tbleStudents and tbleSections. Students are assigned to Sections. The queryStudCount shows how many students are enrolled in each Section.



For example, if there are two sections, Alpha and Bravo with 4 and 7 students, respectively, the query table shows these counts.

How can I display these numbers for a specific section in a field in a form? I used this expression in the control source for a field called studCount and can't get the correct count to display for either Alpha and Bravo

=DLookUp("CountOfstudentNo","StudCount""[????]")

Is the problem in the parameter field and how this should be written? Without the parameter, the expression returns a number, but not specific for the section.

By the way, in the form is another field for sectionName, which is also a field in the query. Do I need to establish a relationship between these fields in the form and query? How?

Many thanks for any help I can get.

[orange]

What exactly are the fields in each table?
I think you need a relationship between the tables.

For example:
If you had 10 students and 3 sections, how would you know which student is in which section? What relates Student to Section.

[celito]

In the Students Table the fields are: student number and student name. In the Sections Table, the fields are section number, section name. I have a third table (Section Assignment) where I assign the students to a section. The fields in the Section Assignment table are section number, section name (from the Sections Table), student number and student name (from the Students Table). The query returns the number of students enrolled in each section. I wanted a field in the Section Assignment table that would return the value of the query when I click on section from the drop down list so that I would know the running total of students in that section. The query is working. I just want to copy that value in a field in the form.