Hi

I have  a main form and a subform. In both the subform and main form, I have the same dropdown field called Status. I would like Status in the subformto dynamically populate the status in the main form. I will have several records in the subform but would like the Status to be from the latest entry to be populated in the Main form.

Hope some can assist.