My "beforeUpdate" event doesn't seem to work. As a test I tried the following two lines of code entering different temperatures on my input form. I expected to see different values, the first from the forms underlying table and the second from the control value entered on the form. I was surprised when the msgbox's displayed the same temperature values.
Private Sub lastName_BeforeUpdate(Cancel As Integer)
MsgBox [tableData_temp] '<--- from the forms base table
MsgBox me!formData_temp '<--- from an input field