I am trying to update a field, in a form, with information based on another field in the same form. For example, When I choose “John Doe” for the name field (a list box), I would like the “Dept” field to automatically update with John Doe’s dept.