Bound boxes, fileds or whatever.

  • Thread starter Thread starter FBrnstrmr
  • Start date Start date
F

FBrnstrmr

What is a bound item, why is it bound and how do I know when I need it or
not? Thanks very much,
-F
 
"What is a bound item, why is it bound "

ControlSource has the name of a field in the form RecordSource if it is
bound to a table

"how do I know when I need it or not?"

unless your form is a menu form, it should generally have a Recordsource
and bound controls so that you can display, add, edit, and delete data
in your tables

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
 
FBrnstrmr said:
What is a bound item, why is it bound and how do I know when I need it or
not? Thanks very much,
Click to expand...

A bound Form is one that has a Table or Query specified in its Record Source
(the Record Source is a Property of the Form) telling Access from where to
retrieve, display, and update the data in that Record Source without your
having to write code or macros to do so. A Bound Report also has a Record
Source, as above, telling Access from where to retrieve the information to
be displayed. A Bound Control is one that has a Control Source (a Property
of the Control) specifying a Field in the Record Source or an expression.

Your questions read to me as if you need a recommendation on some
beginner-level books or tutorials. A really good book for the new user is
"Microsoft Access Step by Step" from Microsoft Press. MVP Crystal Long has
created and published some freely downloadable tutorials at
http://www.accessmvp.com/Strive4Peace/Index.htm. Other tutorials on current
versions of Office software can be found in the training links at
http://office.microsoft.com.

Larry Linson
Microsoft Office Access MVP
 
Thanks Larry, Actually my basic experiences go wayyyyy back to gwbasic,
basica etc. This is all new but somehow the same. One difference being when I
needed a command I could type help and get the list and a breakdown and
example of its use. Obviously I have been left behind and now is the time I
must atch up but there is no quick reference as was available partly because
of the vast volume of growth it has undergone. In any case I amreading
crystalsfine work as I wait for an answer, but I probably won't find what I
need quickly enough. The control source has been described and I understand
from its name that it supplies the info I need to track and that it also
records it but I haven't found outhow that is possible. My combobox uses a
separate table with 41 choices, one of which I need to associate with an
address and a specific date, if I make the table with mt choices my
controlsource how do I get that choice into a separate table? Thanks for your
patience.. -F
 
Back
Top