I have a DLOOKUP function as the bound source for a text box which returns a value based on a value entered in another control on a form. This works fine when the form loads or a new record is added. However if I change the source value for the DLOOKUP function the function does not update/refresh to reflect the change. Is there a way to have the form run the lookup when the source value changes without having to close and re-open the form??