so I have a main form call PO_Update. in the main form, i have a Subform called Update_Detail.

Subform Update_Detail has Update_Detail_DateTime, Update_Status, Update_Note.

on PO_Update form, I want to show Latest_Status that is a latest record from Update_Status sort by Update_Detail_DateTime.

please help me what to do to autofill this Latest_Status automatically?

Thank you in advance