A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Value List" Box



 
 
Thread Tools Display Modes
  #11  
Old May 1st, 2006, 04:40 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default form records not stored in table

Yes, from datasheet view, the records can be updated, but not from the form
itself.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
This should be updating the table if you make changes on the form. If you
open the datasheet view of the form's record source, can you update
records?

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
m...
Control Source: Q5 (field in the record source)
Column Count: 1
Column Widths: 1"
Bound Column: 1
Row Source: "";"Strongly Agree";"Agree";"No Opinion";"Disagree";"Strongly
Disagree";"No Answer"
Row Source Type: Value List

Confirm that the value in Control Source is also in the field list.


If what you're asking is whether, in this case, 'Q5' exists as a field in
the table that acts as record source, then I can confirm.

Many thanks,

Sonia


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
I have never heard of developers having issues with text boxes, combo
boxes, list boxes, and other controls bound to fields in a form's record
source. If your only issue is with list or combo boxes, find one that
doesn't seem to work and provide these properties for us to review:

Control Source:
Column Count:
Column Widths:
Bound Column:
Row Source:
Row Source Type:

Confirm that the value in Control Source is also in the field list.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
om...
I appreciate your help and I will certainly recreate the form.

I am, however, uncertain that the answer is in my doing the same things
I did before without making the same unidentified mistakes.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
If you have controls that are bound to fields in your form's record
source and what you enter into these controls is not updating the
record source, you have serious issues. Try recreate your form.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
et...
"Yes" to both questions: all the controls have a corresponding field
from the record source (i.e., table) as their control sources.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
1) does your form have a Record Source
2) do you controls have a field from the Record Source as their
Control Sources

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
The problem now extends beyond the list boxes. I have other fields
that are 1) not updating the record source and, when a new record
is created, 2) the entries from the previous record will populate
that record.

I've tried working this on my own and I really can't figure it out.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Values from list boxes will be stored in the form's record source
if the list boxes have a control source that is a field from the
record source.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
Using Access 2003, I created a form with a number of list boxes.
I subsequently read online that "Value List" boxes do not, in
fact, populate the source table. However, when creating test
records, I noticed that some box contents were populating some
fields and others not. How do I create list boxes that will
populate all the source fields in a table?

Although I appreciate all offers of help, please note that I'm
not a programmer.

Sonia





















  #12  
Old May 2nd, 2006, 04:51 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default form records not stored in table

I can't imagine what is happening in your database. I would consider
accepting a small sample (compacted) of you application to review and reply.
Email me off line if this would work for you.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
Yes, from datasheet view, the records can be updated, but not from the
form itself.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
This should be updating the table if you make changes on the form. If you
open the datasheet view of the form's record source, can you update
records?

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
m...
Control Source: Q5 (field in the record source)
Column Count: 1
Column Widths: 1"
Bound Column: 1
Row Source: "";"Strongly Agree";"Agree";"No
Opinion";"Disagree";"Strongly Disagree";"No Answer"
Row Source Type: Value List

Confirm that the value in Control Source is also in the field list.

If what you're asking is whether, in this case, 'Q5' exists as a field
in the table that acts as record source, then I can confirm.

Many thanks,

Sonia


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
I have never heard of developers having issues with text boxes, combo
boxes, list boxes, and other controls bound to fields in a form's record
source. If your only issue is with list or combo boxes, find one that
doesn't seem to work and provide these properties for us to review:

Control Source:
Column Count:
Column Widths:
Bound Column:
Row Source:
Row Source Type:

Confirm that the value in Control Source is also in the field list.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
om...
I appreciate your help and I will certainly recreate the form.

I am, however, uncertain that the answer is in my doing the same
things I did before without making the same unidentified mistakes.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
If you have controls that are bound to fields in your form's record
source and what you enter into these controls is not updating the
record source, you have serious issues. Try recreate your form.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
et...
"Yes" to both questions: all the controls have a corresponding field
from the record source (i.e., table) as their control sources.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
1) does your form have a Record Source
2) do you controls have a field from the Record Source as their
Control Sources

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
The problem now extends beyond the list boxes. I have other fields
that are 1) not updating the record source and, when a new record
is created, 2) the entries from the previous record will populate
that record.

I've tried working this on my own and I really can't figure it
out.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Values from list boxes will be stored in the form's record source
if the list boxes have a control source that is a field from the
record source.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
Using Access 2003, I created a form with a number of list boxes.
I subsequently read online that "Value List" boxes do not, in
fact, populate the source table. However, when creating test
records, I noticed that some box contents were populating some
fields and others not. How do I create list boxes that will
populate all the source fields in a table?

Although I appreciate all offers of help, please note that I'm
not a programmer.

Sonia























  #13  
Old May 2nd, 2006, 04:39 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default form records not stored in table

It does work for me, thank you very much. I can't tell you how much I
appreciate all the time you've taken to help me through this. But, I can't
determine your email. Please email me with it?

Sonia


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
I can't imagine what is happening in your database. I would consider
accepting a small sample (compacted) of you application to review and
reply. Email me off line if this would work for you.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
Yes, from datasheet view, the records can be updated, but not from the
form itself.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
This should be updating the table if you make changes on the form. If
you open the datasheet view of the form's record source, can you update
records?

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
m...
Control Source: Q5 (field in the record source)
Column Count: 1
Column Widths: 1"
Bound Column: 1
Row Source: "";"Strongly Agree";"Agree";"No
Opinion";"Disagree";"Strongly Disagree";"No Answer"
Row Source Type: Value List

Confirm that the value in Control Source is also in the field list.

If what you're asking is whether, in this case, 'Q5' exists as a field
in the table that acts as record source, then I can confirm.

Many thanks,

Sonia


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
I have never heard of developers having issues with text boxes, combo
boxes, list boxes, and other controls bound to fields in a form's
record source. If your only issue is with list or combo boxes, find one
that doesn't seem to work and provide these properties for us to
review:

Control Source:
Column Count:
Column Widths:
Bound Column:
Row Source:
Row Source Type:

Confirm that the value in Control Source is also in the field list.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
om...
I appreciate your help and I will certainly recreate the form.

I am, however, uncertain that the answer is in my doing the same
things I did before without making the same unidentified mistakes.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
If you have controls that are bound to fields in your form's record
source and what you enter into these controls is not updating the
record source, you have serious issues. Try recreate your form.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
et...
"Yes" to both questions: all the controls have a corresponding
field from the record source (i.e., table) as their control
sources.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
1) does your form have a Record Source
2) do you controls have a field from the Record Source as their
Control Sources

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
The problem now extends beyond the list boxes. I have other
fields that are 1) not updating the record source and, when a new
record is created, 2) the entries from the previous record will
populate that record.

I've tried working this on my own and I really can't figure it
out.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Values from list boxes will be stored in the form's record
source if the list boxes have a control source that is a field
from the record source.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
Using Access 2003, I created a form with a number of list
boxes. I subsequently read online that "Value List" boxes do
not, in fact, populate the source table. However, when creating
test records, I noticed that some box contents were populating
some fields and others not. How do I create list boxes that
will populate all the source fields in a table?

Although I appreciate all offers of help, please note that I'm
not a programmer.

Sonia

























  #14  
Old May 3rd, 2006, 03:38 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default form records not stored in table

My email is Duane At Hookom Dot Net. You shouldn't post your
email address unless your want to get a ton of spam.

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. net...
It does work for me, thank you very much. I can't tell you how much I
appreciate all the time you've taken to help me through this. But, I can't
determine your email. Please email me with it?

Sonia


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
I can't imagine what is happening in your database. I would consider
accepting a small sample (compacted) of you application to review and
reply. Email me off line if this would work for you.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
Yes, from datasheet view, the records can be updated, but not from the
form itself.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
This should be updating the table if you make changes on the form. If
you open the datasheet view of the form's record source, can you update
records?

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
m...
Control Source: Q5 (field in the record source)
Column Count: 1
Column Widths: 1"
Bound Column: 1
Row Source: "";"Strongly Agree";"Agree";"No
Opinion";"Disagree";"Strongly Disagree";"No Answer"
Row Source Type: Value List

Confirm that the value in Control Source is also in the field list.

If what you're asking is whether, in this case, 'Q5' exists as a field
in the table that acts as record source, then I can confirm.

Many thanks,

Sonia


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
I have never heard of developers having issues with text boxes, combo
boxes, list boxes, and other controls bound to fields in a form's
record source. If your only issue is with list or combo boxes, find
one that doesn't seem to work and provide these properties for us to
review:

Control Source:
Column Count:
Column Widths:
Bound Column:
Row Source:
Row Source Type:

Confirm that the value in Control Source is also in the field list.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
om...
I appreciate your help and I will certainly recreate the form.

I am, however, uncertain that the answer is in my doing the same
things I did before without making the same unidentified mistakes.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
If you have controls that are bound to fields in your form's record
source and what you enter into these controls is not updating the
record source, you have serious issues. Try recreate your form.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
et...
"Yes" to both questions: all the controls have a corresponding
field from the record source (i.e., table) as their control
sources.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
1) does your form have a Record Source
2) do you controls have a field from the Record Source as their
Control Sources

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
The problem now extends beyond the list boxes. I have other
fields that are 1) not updating the record source and, when a
new record is created, 2) the entries from the previous record
will populate that record.

I've tried working this on my own and I really can't figure it
out.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Values from list boxes will be stored in the form's record
source if the list boxes have a control source that is a field
from the record source.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
Using Access 2003, I created a form with a number of list
boxes. I subsequently read online that "Value List" boxes do
not, in fact, populate the source table. However, when
creating test records, I noticed that some box contents were
populating some fields and others not. How do I create list
boxes that will populate all the source fields in a table?

Although I appreciate all offers of help, please note that I'm
not a programmer.

Sonia



























  #15  
Old May 3rd, 2006, 05:18 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default form records not stored in table

I believe the issue was the use of a list box control with a height that
displayed only a single value. Scrolling the list box to "display" a value
does not select the value. The user must scroll and then click the value to
actually update the field. My recommendation was to change the list boxes to
combo boxes.

--
Duane Hookom
MS Access MVP

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
My email is Duane At Hookom Dot Net. You shouldn't post your
email address unless your want to get a ton of spam.

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. net...
It does work for me, thank you very much. I can't tell you how much I
appreciate all the time you've taken to help me through this. But, I
can't determine your email. Please email me with it?

Sonia


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
I can't imagine what is happening in your database. I would consider
accepting a small sample (compacted) of you application to review and
reply. Email me off line if this would work for you.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
Yes, from datasheet view, the records can be updated, but not from the
form itself.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
This should be updating the table if you make changes on the form. If
you open the datasheet view of the form's record source, can you
update records?

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
m...
Control Source: Q5 (field in the record source)
Column Count: 1
Column Widths: 1"
Bound Column: 1
Row Source: "";"Strongly Agree";"Agree";"No
Opinion";"Disagree";"Strongly Disagree";"No Answer"
Row Source Type: Value List

Confirm that the value in Control Source is also in the field list.

If what you're asking is whether, in this case, 'Q5' exists as a
field in the table that acts as record source, then I can confirm.

Many thanks,

Sonia


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
I have never heard of developers having issues with text boxes, combo
boxes, list boxes, and other controls bound to fields in a form's
record source. If your only issue is with list or combo boxes, find
one that doesn't seem to work and provide these properties for us to
review:

Control Source:
Column Count:
Column Widths:
Bound Column:
Row Source:
Row Source Type:

Confirm that the value in Control Source is also in the field list.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
om...
I appreciate your help and I will certainly recreate the form.

I am, however, uncertain that the answer is in my doing the same
things I did before without making the same unidentified mistakes.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
If you have controls that are bound to fields in your form's
record source and what you enter into these controls is not
updating the record source, you have serious issues. Try recreate
your form.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
et...
"Yes" to both questions: all the controls have a corresponding
field from the record source (i.e., table) as their control
sources.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
1) does your form have a Record Source
2) do you controls have a field from the Record Source as their
Control Sources

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
The problem now extends beyond the list boxes. I have other
fields that are 1) not updating the record source and, when a
new record is created, 2) the entries from the previous record
will populate that record.

I've tried working this on my own and I really can't figure it
out.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Values from list boxes will be stored in the form's record
source if the list boxes have a control source that is a field
from the record source.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
Using Access 2003, I created a form with a number of list
boxes. I subsequently read online that "Value List" boxes do
not, in fact, populate the source table. However, when
creating test records, I noticed that some box contents were
populating some fields and others not. How do I create list
boxes that will populate all the source fields in a table?

Although I appreciate all offers of help, please note that
I'm not a programmer.

Sonia





























  #16  
Old May 3rd, 2006, 07:11 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default form records not stored in table

Yep, it worked. Many thanks!

If this an issue with list boxes, what is the point of using a list box
instead of a combo box?


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
I believe the issue was the use of a list box control with a height that
displayed only a single value. Scrolling the list box to "display" a value
does not select the value. The user must scroll and then click the value to
actually update the field. My recommendation was to change the list boxes
to combo boxes.

--
Duane Hookom
MS Access MVP

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
My email is Duane At Hookom Dot Net. You shouldn't post your
email address unless your want to get a ton of spam.

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. net...
It does work for me, thank you very much. I can't tell you how much I
appreciate all the time you've taken to help me through this. But, I
can't determine your email. Please email me with it?

Sonia


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
I can't imagine what is happening in your database. I would consider
accepting a small sample (compacted) of you application to review and
reply. Email me off line if this would work for you.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
Yes, from datasheet view, the records can be updated, but not from the
form itself.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
This should be updating the table if you make changes on the form. If
you open the datasheet view of the form's record source, can you
update records?

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
m...
Control Source: Q5 (field in the record source)
Column Count: 1
Column Widths: 1"
Bound Column: 1
Row Source: "";"Strongly Agree";"Agree";"No
Opinion";"Disagree";"Strongly Disagree";"No Answer"
Row Source Type: Value List

Confirm that the value in Control Source is also in the field
list.

If what you're asking is whether, in this case, 'Q5' exists as a
field in the table that acts as record source, then I can confirm.

Many thanks,

Sonia


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
I have never heard of developers having issues with text boxes,
combo boxes, list boxes, and other controls bound to fields in a
form's record source. If your only issue is with list or combo
boxes, find one that doesn't seem to work and provide these
properties for us to review:

Control Source:
Column Count:
Column Widths:
Bound Column:
Row Source:
Row Source Type:

Confirm that the value in Control Source is also in the field list.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
om...
I appreciate your help and I will certainly recreate the form.

I am, however, uncertain that the answer is in my doing the same
things I did before without making the same unidentified mistakes.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
If you have controls that are bound to fields in your form's
record source and what you enter into these controls is not
updating the record source, you have serious issues. Try recreate
your form.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
et...
"Yes" to both questions: all the controls have a corresponding
field from the record source (i.e., table) as their control
sources.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
1) does your form have a Record Source
2) do you controls have a field from the Record Source as their
Control Sources

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
The problem now extends beyond the list boxes. I have other
fields that are 1) not updating the record source and, when a
new record is created, 2) the entries from the previous record
will populate that record.

I've tried working this on my own and I really can't figure it
out.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Values from list boxes will be stored in the form's record
source if the list boxes have a control source that is a
field from the record source.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
Using Access 2003, I created a form with a number of list
boxes. I subsequently read online that "Value List" boxes do
not, in fact, populate the source table. However, when
creating test records, I noticed that some box contents were
populating some fields and others not. How do I create list
boxes that will populate all the source fields in a table?

Although I appreciate all offers of help, please note that
I'm not a programmer.

Sonia































  #17  
Old May 4th, 2006, 04:18 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default form records not stored in table

Normally list boxes are used for smaller lists and lists where you might
want to select multiple values. You rarely if ever create list boxes sized
so only one item from the list is visible. I can't remember using a list box
that is bound to a field for storing the value in a table. Combo boxes are
much more popular.

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. net...
Yep, it worked. Many thanks!

If this an issue with list boxes, what is the point of using a list box
instead of a combo box?


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
I believe the issue was the use of a list box control with a height that
displayed only a single value. Scrolling the list box to "display" a value
does not select the value. The user must scroll and then click the value
to actually update the field. My recommendation was to change the list
boxes to combo boxes.

--
Duane Hookom
MS Access MVP

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
My email is Duane At Hookom Dot Net. You shouldn't post
your email address unless your want to get a ton of spam.

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. net...
It does work for me, thank you very much. I can't tell you how much I
appreciate all the time you've taken to help me through this. But, I
can't determine your email. Please email me with it?

Sonia


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
I can't imagine what is happening in your database. I would consider
accepting a small sample (compacted) of you application to review and
reply. Email me off line if this would work for you.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
Yes, from datasheet view, the records can be updated, but not from
the form itself.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
This should be updating the table if you make changes on the form.
If you open the datasheet view of the form's record source, can you
update records?

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
m...
Control Source: Q5 (field in the record source)
Column Count: 1
Column Widths: 1"
Bound Column: 1
Row Source: "";"Strongly Agree";"Agree";"No
Opinion";"Disagree";"Strongly Disagree";"No Answer"
Row Source Type: Value List

Confirm that the value in Control Source is also in the field
list.

If what you're asking is whether, in this case, 'Q5' exists as a
field in the table that acts as record source, then I can confirm.

Many thanks,

Sonia


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
I have never heard of developers having issues with text boxes,
combo boxes, list boxes, and other controls bound to fields in a
form's record source. If your only issue is with list or combo
boxes, find one that doesn't seem to work and provide these
properties for us to review:

Control Source:
Column Count:
Column Widths:
Bound Column:
Row Source:
Row Source Type:

Confirm that the value in Control Source is also in the field
list.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
om...
I appreciate your help and I will certainly recreate the form.

I am, however, uncertain that the answer is in my doing the same
things I did before without making the same unidentified
mistakes.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
If you have controls that are bound to fields in your form's
record source and what you enter into these controls is not
updating the record source, you have serious issues. Try
recreate your form.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
et...
"Yes" to both questions: all the controls have a corresponding
field from the record source (i.e., table) as their control
sources.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
1) does your form have a Record Source
2) do you controls have a field from the Record Source as
their Control Sources

--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
The problem now extends beyond the list boxes. I have other
fields that are 1) not updating the record source and, when a
new record is created, 2) the entries from the previous
record will populate that record.

I've tried working this on my own and I really can't figure
it out.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Values from list boxes will be stored in the form's record
source if the list boxes have a control source that is a
field from the record source.
--
Duane Hookom
MS Access MVP

"smcalles" wrote in message
. com...
Using Access 2003, I created a form with a number of list
boxes. I subsequently read online that "Value List" boxes
do not, in fact, populate the source table. However, when
creating test records, I noticed that some box contents
were populating some fields and others not. How do I create
list boxes that will populate all the source fields in a
table?

Although I appreciate all offers of help, please note that
I'm not a programmer.

Sonia

































 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
"Recently used file list" has disappeared. Frank Martin New Users 3 January 12th, 2006 09:04 PM
"Recently used file list" Alphabetically Rick General Discussion 1 January 6th, 2006 04:58 PM
my archive folder is no longer in the "folder list"? Todd H General Discussion 2 November 16th, 2005 10:33 PM
Outlook Rt click "Add Sender's Domain to BLOCKED sender's list" john85374 General Discussion 2 September 22nd, 2005 11:16 AM


All times are GMT +1. The time now is 09:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.