text Box

[bill]

Hello All
I inserted a text box in my form, how can i set it to save for every record
ie I want the comments to stay on the record not to move to another

 

[Douglas J. Steele]

You mean you added an unbound text box (i.e.: no field was specified for its
ControlSource)? What you're seeing is standard: change the value in an
unbound control for a continuous form and every instance of that control is
updated.

You'd need to bind the text box to the appropriate field in the form's
RecordSource.

 

[Allen Browne]

The form is bound to some table. Open that table in design view, and add
another field of type Memo or Text. Save. Close.

Now open your form in design view, and set the Control Source property of
the text box to whatever you called the new field. The data will be saved in
the field, so it will show up again when you open that record again.

 

[Hans Le Roy]

Hi bill,

Hello All
I inserted a text box in my form, how can i set it to save for every record
ie I want the comments to stay on the record not to move to another

You should add a textbox that is unbound.

Kind regards

Hans

 

[RonaldoOneNil]

The textbox needs to be bound to a comments field in your table or query that
is the recordsource for the form.