Adding to Dropdown List

[HankL]

I am using Access 2003
It has been quite some time since I have made changes to a database and
forgot how to enter new selections.
I have a database for restaurants. One of my dropdown boxes allows me to
select Type Food, such as American, Italian, etc.
I want to add other ethnic food types and forgot how to do this.

Could someone please give me instructions to add additional food types to my
dropdown list.
Please make it simple as it is difficult for me to follow very technical
explanations.

 

[Kenny]

I am using Access 2003
It has been quite some time since I have made changes to a database and
forgot how to enter new selections.
I have a database for restaurants.  One of my dropdown boxes allows me to
select Type Food, such as American, Italian, etc.
I want to add other ethnic food types and forgot how to do this.

Could someone please give me instructions to add additional food types tomy
dropdown list.
Please make it simple as it is difficult for me to follow very technical
explanations.

Hank,

I am guessing the values are hard coded in the dropdown (combo box).
Go into design view of the form. Select the combo box control in
question. Do a right mouse click and select properties. Go to the Data
tab. Look at Row Source Type (3rd in list) and I am guessing it says
Value List (which are the values you type in). The next item is Row
Source, each of the entries you see in the combo box are typed here.
Seperate each value with a semicolon. Hope this helps.

Kenny

 

[fredg]

I am using Access 2003
It has been quite some time since I have made changes to a database and
forgot how to enter new selections.
I have a database for restaurants. One of my dropdown boxes allows me to
select Type Food, such as American, Italian, etc.
I want to add other ethnic food types and forgot how to do this.

Could someone please give me instructions to add additional food types to my
dropdown list.
Please make it simple as it is difficult for me to follow very technical
explanations.

This was asked and you received 3 replies on 10/12.
If you didn't understand the previous replies, or they didn't work for
you, simply re-asking the identical question without adding additional
information nor explaining what you have done is not going to improve
your chances of getting a worthwhile answer to your question.

 

[John W. Vinson]

I am using Access 2003
It has been quite some time since I have made changes to a database and
forgot how to enter new selections.
I have a database for restaurants. One of my dropdown boxes allows me to
select Type Food, such as American, Italian, etc.
I want to add other ethnic food types and forgot how to do this.

Could someone please give me instructions to add additional food types to my
dropdown list.
Please make it simple as it is difficult for me to follow very technical
explanations.

Open the Form in design view.
Right Click on the combo box ("dropdown"). Select "Properties" to view them.
One of the properties is "Row Source Type". It will be either "List of Values"
or "Table/Query".

If it's List of Values, click into the adjacent "Row Source" property. It will
contain a bunch of text, in quotes, separated by semicolons, like

"American";"Italian"; <etc>

Edit it to include whatever new types you want (I'd suggest
"Szechuan";"Hunanese";"Punjabi";"Kerala" <g>).

If the Row Source Type is Query/Table, click the ... icon by the Row Source
property. A query design window will open. Click the datasheet icon - leftmost
in the toolbar. Enter the types you want in the query datasheet (along with
any other information that's needed, I have no way to know how your tables
might be set up). Close the query window and accept Access' offer to update
the property.

If you have trouble, post back with the rowsource type, what you see in "Row
Source", and any other information that might be useful.