Find Max Value From Selection

[DMerchen]

I have a table with IDs 50-59 only, and part numbers that are added by entering a value. I want to find a max value of a part number based on a dropdown. For example, if I choose Divergent from the dropdown, it is group 55, then I want to find the highest part number of that group. Is this possible? I think it is, but just can't wrap my head around it. I have attached images to help, anyway...I hope they help. In one image you can see the group, then the part numbers. On my form if I choose a group I want it to be able to find the Max part number for that group in the table.

Thanks for the assistance,
Dave

 

[arnelgp]

you can use DMax function:

DMax("PartNumberField","table1","GroupField=" & Me.Combo)

substitute the correct fieldname, tablename and comboname to
the above PartNumberField, table1, Groupfield, Combo