access forms--adding controls

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.
 
F

Fredg

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.
 
H

Hugh O'Neill

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.


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top