If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data entry into table field.
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 |
#2
|
|||
|
|||
Data entry into table field.
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 |
#3
|
|||
|
|||
Data entry into table field.
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 |
#4
|
|||
|
|||
Data entry into table field.
after adding the controlsource I cannot choose antry from the combobox it says
"can't be edited it is bound to the expression ....etc." "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 |
#5
|
|||
|
|||
Data entry into table field.
Please make that "choose an entry" Thanks.
"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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
Data entry into table field.
that means you used an equation as the Controlsource -- not the name of
a field. In the controlsource property, make a choice from the list (note the arrow on the right when you click in that property) 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: after adding the controlsource I cannot choose antry from the combobox it says "can't be edited it is bound to the expression ....etc." "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 |
#8
|
|||
|
|||
Data entry into table field.
On Mon, 12 Jan 2009 17:21:02 -0800, FBrnstrmr
wrote: 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? STOP. Read Crystal's tutorials. You're going about this backwards; Tables are the foundation of the house, Forms are the windows and windowframes. You don't start assembling the windows and windowframes into the house and then start thinking about where to pour the foundation! -- John W. Vinson [MVP] |
#9
|
|||
|
|||
Data entry into table field.
So I am looking for the difference between rowsource, controlsource and
recordsource. I am reading your info. source now, but I can't relate to all the hundreds of extraneous terms so I need to focus just on the ones I require at the moment, or it will take months to do what I need. It is very good info though. Thanks for doing it for everyone! "strive4peace" wrote: 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 |
#10
|
|||
|
|||
Data entry into table field.
you're welcome
the information in "Properties and Methods" is essential to understanding these terms -- the ones that are pointed out, you pretty much need to know... Form and Report Design -- start reading from page 5-6 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 I am looking for the difference between rowsource, controlsource and recordsource. I am reading your info. source now, but I can't relate to all the hundreds of extraneous terms so I need to focus just on the ones I require at the moment, or it will take months to do what I need. It is very good info though. Thanks for doing it for everyone! |
Thread Tools | |
Display Modes | |
|
|