"Value List" Box

  • Thread starter Thread starter smcalles
  • Start date Start date
S

smcalles

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
 
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.
 
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.
 
1) does your form have a Record Source
2) do you controls have a field from the Record Source as their Control
Sources
 
"Yes" to both questions: all the controls have a corresponding field from
the record source (i.e., table) as their control sources.
 
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.
 
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.
 
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.
 
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

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
 
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?
 
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.
 
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
 
My email is Duane At Hookom Dot Net. You shouldn't post your
email address unless your want to get a ton of spam.
 
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.
 
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?
 
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.
 
Back
Top