i have a field per record to input the class number, then i have a query to filter the records by that class number

I have a database that tracks student information and grades. I am using a form to enter data and the form will post to a table as information is entered. The form is using a query to select students by class number. I have entered a new class number with 16 students into the form. The table has received all information that has been entered. Now when I try to load the new class number in the form none of the records will show. When i attempt...

I have a database that records grades for students and then averages them. I need the results of the average expression to post on the table. Every other field works great. I have tried using the expression in the after update property and the before update property with no results still. I am pretty new at this and any help would be appreciated. Thank you in advance for any help you provide.