Drop down list

[Paul]

I have added a new column is the "Task" table and also set up a drop down
list, after i go and add this new column to the "Task" list form the drop
down button is there but not my lst. i can go back to the table and the drop
down list is there, what am i missing?

 

[Roger Carlson]

You have to requery your combobox rowsource:

DoCmd.Requery "YourCombo"


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Paul]

I'm new to access so how would i do that? Thanks!

 

[Roger Carlson]

Actually, I think I mis-read your question originally.

If I understand correctly, you've added a new column to a table and, on your
form, you have a combo box that uses that table as its Row Source. You see
your new column in the drop-down list, but not in the combo box after making
a selection.

Is that correct?

If so, look at your combo box properties. Modify the Column Count property
and make that equal to the number of columns you expect to see displayed.
Also change your Column Widths property to give values to each of the
columns you want displayed.

If this is not the problem, can you explain further?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Paul]

I am using one of the pre made templates, i am adding two columns to a table
and in these columns i am adding drop down list where i have a list of words
to choose from, i save it and then go to the Forms and i then add these new
columns to the form and they do show up in the form after theve been added,
my problem is that the list is not there ( The drop down button is), so im
trying to get the list to show up that i added.