Due to the current limitations on automation with subforms i find we need to update the main form with data from the subform.

In the main equipment form is a field called equipmentstatus. In the subform is a field called status. I would like to to update the main form field to the latest update of the subform field. Obviously the subform gets new rows so i am only interested in the latest one.

Having spent most of the day going in circles and reading lot of help and even downloading a book i am confused. Plus how do you find the subforms API. all other APIs found but subform nope.