Sean,
in your form, create a textbox, and also a button (onclick)
for example name the textbox "txtNewValue" and the button "clkUpdate" in their properties
On the properties window again, select the clkUpdate button, Event, On Click, [Event Procedure], Module
(I have the Access 2010 so it might...