List Box no displaying added choices

  • Thread starter Thread starter Angela_Marie via AccessMonster.com
  • Start date Start date
A

Angela_Marie via AccessMonster.com

I have several drop-down list boxes in a few forms that I am having trouble
with. When I originally set up the database, I created the tables and
entered a few items to be included in the drop down list in the lookup
section of the table (design view). I then created the forms and inserted
those fields. I have since added several new choices to the drop-down list
of the table, and those new selections are available in the Table, but they
are not available in the Form. The only items available in the drop down
list on the Form are those choices that were originally there when I set up
the form. Please go easy on me, I am very new to this stuff.
Thanks!
 
I have several drop-down list boxes in a few forms that I am having trouble
with. When I originally set up the database, I created the tables and
entered a few items to be included in the drop down list in the lookup
section of the table (design view). I then created the forms and inserted
those fields. I have since added several new choices to the drop-down list
of the table, and those new selections are available in the Table, but they
are not available in the Form. The only items available in the drop down
list on the Form are those choices that were originally there when I set up
the form. Please go easy on me, I am very new to this stuff.
Thanks!
Click to expand...

First off... kill all your Lookup Fields. See
www.mvps.org/access/lookupfields.htm for a critique.

My guess is that when you first created the lookup fields that you used a
"List of Values". You may need to change the Row Source Type property of your
form combo box from "Value List" to "Table/Query", and the Row Source from the
static list to the name of your lookup table.

John W. Vinson [MVP]
 
Back
Top