METHOD 1 - Uses Visual Queries Only
do a query of the assignment table and change this into a totals query - click the large sigma icon on the icon bar - can't explain it any other way - it says "totals" if you hover over it. Include just the personid and assignmentdate in the query. In the total line of the date field select Max from the drop down. This will give you the latest date for the assignment. You can't include other fields or it will mess up your query results. Try it and see.
Instead of basing your form on the person table, noe prepare another query including the person table, and the new maxdate query. You can now include the latestassignmentdate. Base your form on this query and you can now include the latest date on your form.
The max query cannot include other things such as the assignmentid and the score. However, you could also include the assignment table in the latest query (on which you are now basing the form) - You would have to join this to the maxdate query based on the person AND the date - The only trouble is, is that if you have two assignments with the same date, they will both now be picked up in this query.
You may also find the final query is not updateable because of the dmax function, which may give you a problem.
Try this method first though as it is the easiest
METHOD 2
Another way would be to keep your form as is, and to add an unbound text box(es) to include the assignment details you want. However in the oncurrent event for this form, you would then have to write code - you would either have to do a dlookup of the dmax query to retrieve the date, and do further dlookups to retrieve other information, or write SQL statements to do this. You definitely would not have updating problems with this scenario.
