If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I make values from a table show up in a drop down list on .
I'm new at using Access. I have created a table. This table contains data.
One of the data fields is called Area. I have created a form for data entry into the table. On the form I have created a drop down box from which I want to choose a value to be placed in the Area field. However, I cannot figure out how to make the drop down box contain more than one value. I tried a combo box as well as a list box and still am having no luck. Can someone tell me step-by-step how to accomplish this? |
#2
|
|||
|
|||
Go to the recordsource and select the table containing area.
Then select the field Area. "Printing Field Name List" wrote in message ... I'm new at using Access. I have created a table. This table contains data. One of the data fields is called Area. I have created a form for data entry into the table. On the form I have created a drop down box from which I want to choose a value to be placed in the Area field. However, I cannot figure out how to make the drop down box contain more than one value. I tried a combo box as well as a list box and still am having no luck. Can someone tell me step-by-step how to accomplish this? |
#3
|
|||
|
|||
When you say "Go to the recordsource", I don't know what you mean. In the
form I can click on properties for the drop down box I created and click on Control Source but there is nothing called record source. "Chris" wrote: Go to the recordsource and select the table containing area. Then select the field Area. "Printing Field Name List" wrote in message ... I'm new at using Access. I have created a table. This table contains data. One of the data fields is called Area. I have created a form for data entry into the table. On the form I have created a drop down box from which I want to choose a value to be placed in the Area field. However, I cannot figure out how to make the drop down box contain more than one value. I tried a combo box as well as a list box and still am having no luck. Can someone tell me step-by-step how to accomplish this? |
#4
|
|||
|
|||
select your combobox, go to the properties, select the all tab, the second option is control source, the sixth option is "row source type" set this to table / query. the seventh one down in control source. If you put your mouse in this then you will see two options to your right. one is a square with 3 dots in it. Click this button. then select your table that contains the area. Select the area and this will appear down at the bottom. "Printing Field Name List" wrote in message ... When you say "Go to the recordsource", I don't know what you mean. In the form I can click on properties for the drop down box I created and click on Control Source but there is nothing called record source. "Chris" wrote: Go to the recordsource and select the table containing area. Then select the field Area. "Printing Field Name List" wrote in message ... I'm new at using Access. I have created a table. This table contains data. One of the data fields is called Area. I have created a form for data entry into the table. On the form I have created a drop down box from which I want to choose a value to be placed in the Area field. However, I cannot figure out how to make the drop down box contain more than one value. I tried a combo box as well as a list box and still am having no luck. Can someone tell me step-by-step how to accomplish this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update Tables using forms | achett | Using Forms | 5 | January 28th, 2005 12:25 AM |
Is there a way to make a drop down list in Excel that lets you se. | Pasting column width and row heights | Worksheet Functions | 1 | January 20th, 2005 04:15 PM |
how do i narrow down the items in a pivot table drop down list? | bac9999 | Charts and Charting | 1 | November 11th, 2004 03:33 PM |
Make form checkboxes from table list | Svein Engebretsen | Using Forms | 1 | October 12th, 2004 07:08 PM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |