If your form is "bound" to a recordsource (table or view), the textbox's control source would be the name of the column in the recordsource that will receive the value. You can open the textbox properties and click on the dropdown for the control source to see a list of columns. Then just pick the correct one.