sort of but not exactly ...
your form must have the RecordSource = name of table (or query) you want
to add records to
the RowSource of the combo has no effect on data that is created -- that
only serves as a list of choices
the ControlSource of the combo will be the fieldname in the form
Recordsource that you want to display or update
a new record will be added ONLY if you are on a new record before you
start filling things out
I would suggest you take 2 hours to read the first part of Access Basics
as you will waste much more time than that if you don't -- you need to
have more understanding than you do
be sure to at least read the following sections:
Normalization
Relationships
Properties and Methods
Forms
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 wrote:
So if I have a table I am using as a datasource for a combo-box in my form,
if I use the field name of my intended storage table as the ControlSource of
the combo-box on my form it will be added to that table as a new record?
Thanks I will try that. and if I didn't have a deadline I would much rather
have read your tutorial first.;-} I definitely will, after I get this done
so I can do it better.
"strive4peace" wrote:
the ControlSource is the field name (from the form RecordSource) that
the combo is bound to
"How do I link the form data to the table once it is made"
put the table name in the form RecordSource
to create a new record, click the [*] button in the lower left corner
of the screen where the navigation buttons are
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 wrote:
How does the data chosen from a drop-down list or combo box get entered into
the table field? How is it linked to the record as opposed to (or in addition
to) the combo-box? I appear to have worked in reverse in that I created a
Form to enter data from a combo-box, but don't yet have the place to store
the chosen data. How do I link the form data to the table once it is made,
please? Since the data will be new how does it create a new record for that
data?
Thanks in advance for any help you may provide.
-F