I have a form that has a dropdown of each “user”. Each User has a sequential numeric list of “cases”. I created a Query and subform to find the Max number and add 1 for each User’s Cases. However, doing it that way I don’t think it is possible to copy the new case number into the form. Is there an alternate way to find and populate the next sequential case number for each user into the form?