I am currently using the below code for a field on a form. It works perfect when we click to a new form. If we update the combo box: cmOffice it doesn't update the DLookup. Is there an "After Update" event I can add for the cmOffice?
The name of the field that needs updated is: txtOfficeName