Modifying The List Box

B

B. Wilkes

I need to add names to my list box but when I go to data sheet view or form
design it will not allow we to add more names for selection, just change the
one that's in it. Can someone pls advise on this? Thanks
 
R

Rick Brandt

B. Wilkes said:
I need to add names to my list box but when I go to data sheet view
or form design it will not allow we to add more names for selection,
just change the one that's in it. Can someone pls advise on this?
Thanks
Click to expand...

In design view of the form select the ListBox and then examine the property
sheet for the property named RowSourceType.

If it indicates "Table/Query" then that means the ListBox is getting its
list of choices from a Table in your database. You would need to add the
new choices to that table. Looking at the next property down (RowSource)
should identify the table or query being used by the ListBox. Once you see
which table that the RowSource is using you can open that table seperately
and make your new entries.

It it indicates "Value List" then the RowSource is a text list of choices
seperated by semi-colons. Just click in that property and add the new
choices.
 
Top