I want to replace all data in one field of a query by something that was typed in a textbox on a form.

How can I do this?

This is a basic Update Query, where an extra line will pop-up in your Query Design Grid and you 'replace' text in the selected field, according to the criteria you set.