Data entry into table field.

[FBrnstrmr]

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

 

[strive4peace]

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]

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.

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
*

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

 

[FBrnstrmr]

after adding the controlsource I cannot choose antry from the combobox it says
"can't be edited it is bound to the expression ....etc."

:

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
*

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

 

[FBrnstrmr]

Please make that "choose an entry" Thanks.

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
*

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

 

[strive4peace]

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
*

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.

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
*

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

 

[strive4peace]

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
*

after adding the controlsource I cannot choose antry from the combobox it says
"can't be edited it is bound to the expression ....etc."

:

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
*

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

 

[John W. Vinson]

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!

 

[FBrnstrmr]

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!

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
*

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.

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

 

[strive4peace]

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]

You are of course absolutrly correct, but I did so because the down arrow to
which you refer simply shows an empty box and so there is nothing from which
to choose.
(I am reading the form and report design right now, interestings tips there,
but the TRIM (command?) didn't work. I am trying to show a concatenated field
of 2 numbers but there is always a space, even after I left justified the
right hand (or second) number.
I am very grateful for all your help, please don't give up on me. Thanks
very much.
-F

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
*

after adding the controlsource I cannot choose antry from the combobox it says
"can't be edited it is bound to the expression ....etc."

:

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

 

[FBrnstrmr]

Thanks John, I am becoming increasingly aware of that and agrre entirely, but
I have what I have now, and am attempting to salvage both my work and my
dignity, what little is left, of course. I know what I wish to do but I am in
the unfortunate situation of having to work backwards. Fortunately the
windows and doors are suspended in cyberspace until I build the frame around
them. They are good doors and windows but I don't wish to drop them and have
to rebuild them when they are already done. My house was easier to build but
I was doing it for me and had the luxury of time, not so in this case. It is
a steep learning curve but not impossible thanks to this great web resource
and people like yourself and Crystal. I only hope I can be as helpful in the
future to others.

 

[strive4peace]

Hi F (what is your name?)

"simply shows an empty box"

you must assign the form RecordSource first ... then you will see the
fields in the Recordsource when you drop the combobox for ControlSource
<smile>

~~~

Trim will work -- but any valid equation must start with =

if you use an equation, you cannot change the information, it will be
for display only


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]

Hi F (what is your name?)

"simply shows an empty box"

you must assign the form RecordSource first ... then you will see the
fields in the Recordsource when you drop the combobox for ControlSource

My form has numerous controls each with its own source line but how do I
assign a source to the total form, I tried but seem to have missed that

<smile>

~~~

Trim will work -- but any valid equation must start with =

if you use an equation, you cannot change the information, it will be

Me.txtBuildID = Trim(Me.cboAddress.Column(5) & Me.cboAddress.Column(6))

 

[FBrnstrmr]

Hi F (what is your name?)

Sorry I forgot this question--- Fred (yes it really is) and I just found out
where to assign the control source to the form. Hidden in the top left corner
just as you described it. But... my form uses data from multiple tables as
sources to coordinate the address, combobox, dropdown lists, and another
cascading combobox requirements that I need for my new database records. can
there be more than control source and/or I also need the table to which this
info will be outputted.ie: my input table of addresses is larger than I need
for my own table, but it is continually being updated by an external group.
The table I am trying to create or "fill" is more of a timebased snapshot of
info regarding some of these locations. As owners change for example the
imported data will reflect that and my table will have to note the change
from then on but not change the historic record from the previous owners
name. So in short, I need mutliple records of the same address while the
date, ownership and other info regardig the address changes. That is why I
have been building backwards, I started with an externally updated database
table in which I can make no changes and need to create another for internal
use with the info gleaned from the first plus any information we require to
track as well.

 

[strive4peace]

Hi Fred,

glad you found the RECORD SOURCE property

you can only have one RecordSource for a form -- that is why it is
advisable to use a main form and subforms if you wish to display and
edit data from multiple tables.

p 5-24: Mainform/subform

you can use a query that gets data from more than one table as a
RecordSource, but if you do that, you may only be able to display data,
not add or edit it

"That is why I have been building backwards"

sounds like you just accepted the way the data was structured wherever
it came from -- this is usually a mistake



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
*

 

[John W. Vinson]

rowsource,

A Query from which a Combo Box or Listbox gets its data from.

controlsource

The field into which any bound control stores its data.

and

recordsource.

A Query which provides the data for a Form.

 

[strive4peace]

Hi John

"Query" ... or Table <smile>

I like to use tables for RecordSource if the data is stored in Access
and it is not necessary to filter the records or calculate anything

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
*

 

[John W. Vinson]

Hi John

"Query" ... or Table <smile>

I like to use tables for RecordSource if the data is stored in Access
and it is not necessary to filter the records or calculate anything

True. Although Access will often create a hidden query in the background (i.e.
if you put a Filter or OrderBy on a form) there's actually a query underneath
it.

 

[strive4peace]

Hi John,

one reason I tell others to use tables is to keep them from creating a
recordset that cannot be updated

btw, I hope I get a chance for one of your back-jobs at the Summit
.... missed out last year

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
*