Value not updating unbound ole object
On a form, you can use a text box that is bound to an updatable record source to enter or edit data in a field.
For example, if you drag a Yes/No field from the Field List pane to a form or report, Access creates a check box.
If you drag an OLE Object field to a form or report, Access creates a bound object frame, and if you drag an attachment field to a form or report, Access creates an attachment control.
You can also add a bound text box to a form or report by first adding an unbound text box, and then setting the Control Source property of the text box to the field you want to bind it to.
Top of Page An unbound text box is not connected to a field in a table or query.
The text box is the standard control used for viewing and editing data on forms and reports.
Many different types of data can be displayed in text boxes, and you can also use them to perform calculations.This article explains how to create and use a text box and also explains some important text box properties.A bound text box displays data from a field in a table or query.You can use an unbound text box to display the results of a calculation or to accept input that you don't want to store directly in a table.It is easiest to add an unbound text box in Design view.Another way to create an unbound text box is by first creating a bound text box by dragging a field from the Field List pane onto the form or report, and then deleting the value in its Control Source property.