I have an unbound Text Box that the user enters data into which is then used by VBA Code when a button is clicked on the Form.
If I use TAB to exit after changing the data then the correct value is used by the code.
However if it loses Focus, ie the Button is clicked, the old value is used...