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
not? Thanks very much,
-F
S
strive4peace
"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
*
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 *
L
Larry Linson
FBrnstrmr said:
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
F
FBrnstrmr
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
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