I have this statement: DoCmd.RunSQL "UPDATE Patient_Registry SET Patient_Registry.[StudyTitle] = " & Me.Studyholder & " WHERE Patient_Registry.ScreenID = '" & Forms![NewStudy]![ScreenID] & "'" When I run it a box comes up and whatever I have in Studyholder it has up at the top of the little box. Then when I type something it updates the field. What am I doing to make this box come up it should just update on its own without being prompted. Patient_Registry is the table which needs the update StudyTitle is the field in Patient_Registy that needs the update Studyholder is the text I would like to be updated The current form is NewStudy ScreenID is the specific place I would like it to be updated at.