View Single Post
  #6  
Old January 13th, 2009, 02:51 AM posted to microsoft.public.access.forms
strive4peace
external usenet poster
 
Posts: 1,670
Default Data entry into table field.

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