access forms--adding controls

  • Thread starter Thread starter sarah
  • Start date Start date
S

sarah

When you add a text box control(using the toolbox) in
design view, why does the text box show up as Unbound,
and when you enter data into the box it copies it to all
records.
 
Sarah,
Because you added the control to the form using the toolbox.

If you wish to bind that control to a particular field, you must select that
field in the control's control source property.

Otherwise, use the Field List tool button to drag a field onto the form. Now
it will be automatically bound to a field in the table.
 
sarah said:
When you add a text box control(using the toolbox) in
design view, why does the text box show up as Unbound,
and when you enter data into the box it copies it to all
records.
Click to expand...


In a continuous Form, you are seeing the same row of controls several
times. That is why an entry into an unbound control shows up in all
the other rows.

When you create a control from the Toolbox, unless you say which Field
it is bound to, it will be unbound. To create a bound control, you can
either specify the control's source on the Data tab of its properties,
or drag a Field from the Form's Field List onto the Form.

hth

Hugh
 
Back
Top