in access, what does "unbound" mean?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a beginner and am creating a form from a table. It has text box
properties. The word "unbound" has come up on my design view of my form and
I don't know how it got there or what it means. I think it is making the
same number on every record when I want to enter different numbers in each
record. How do I change it and what did I do to put it there?
 
unbound controls are controls that are not related to the
underlying recordsource of your form. (The info from which
Access fills your form)
Anything typed there is not saved/retrieved by default.
(unless by code)

to bind it, choose properties from the control and look
for the tab Data or something alike
The first property is normally controlsource = field you
wish to save to

I hope this clears a bit up
 
Admin Person said:
I am a beginner and am creating a form from a table. It has text box
properties. The word "unbound" has come up on my design view of my form and
I don't know how it got there or what it means. I think it is making the
same number on every record when I want to enter different numbers in each
record. How do I change it and what did I do to put it there?
Click to expand...

An unbound form is one with no RecordSource entry.

An unbound control is a bit more nebulous. A control with no entry in its
ControlSource property is definitely unbound. It will display empty in normal
view and the user can make an entry, but it is a static entry that has nothing
to do with the underlying records (assuming the form has one).

A control can also use an expression as a ControlSource. If that expression
contains no fields from the form's RecordSource it is still (sort of) unbound in
the sense that it has no connection to the underlying data, but since it has a
ControlSource, it is not "technically" unbound, because it is bound to the
expression.
 
Back
Top