Drop Down Menu? Is it possible?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

To begin, thanks for any help you can give me.
I'm a new user in Access, and thought of making a database were I would put
all the articles in the dozens of newspapers I have kept.
I had some troubles in designind the database structure in my head, but
finnaly I decided I should enter the data by article, and not by newspaper or
subject or actor. Was it the best solution? I'm still to find out...
Anyway, I thought that it would be better to limit the data I enter, and I
thought of doing it with a drop-down menu. For example, I could limit the
data respecting the newspaper where the article is, like NYTimes or
Washington Post; this drop-down menu would only have this two possible
selections to chose.
Unfortunately, I didn't found this option in my Access 2003. Is it there? Is
it possible? How can I do it?
Thanks again for any help you can give me.

Francisco Casal Bom, Portugal
(e-mail address removed)
 
Hi,
Search help for Combo box or just combo.
Combo box is the terminology for a drop down list.

How you set up your tables can be a matter of personal choice.

You could have one combo box that list all subjects.
Selecting a subject would populate a second combo box that lists all
newspapers that subject appears in.
Selecting a newspaper could populate a third box that shows all editions
that the subject appeared in.... and so on.

hth

Mike
 
Hi Mike, and thanks for your help.
I've searched for help for combo box, but it I didn't found where does it's
located in Access. How can I go to that configuration? Is it needed some kind
of programming or is it a selection in boxes?
Thanks again.

"Mike Revis" escreveu:
 
A combo box can get the values that it displays in one of three ways. From
the values in a table, from a list of static values that you provide or it
can display a list of the fields in a table.

I you only want to have two values in the list at all times as you described
in your first post, then you can select the combo box and right click and
select the Properties option. Click on the "Data" tab. From the "Row Source
Type" list, select the "Value List" option. Then in the "Row Source" property
type the values you want to appear in the list, seperating each value with a
simicolpn. For example, if you want the two values you referred to, just type
"NYTimes;Washington Post"

Test your combo box and you should now have these two values available to
select from your combo box. If you want to be able to use these two vales
only and not be able to use any other newspaper name then change the "No" to
"Yes" in the "Limit to list" properties option.
 
1. Create a table (tblNewspaper) with NewspaperID as field and the Primary key.
2. Insert 2 type of newspaper (NYTimes & Washington Post).
3. Create a form and insert a combo box (cboNewspaperID).
4. Insert the following in the Row Source:
SELECT tblNewspaper.NewspaperID
FROM tblNewspaper
ORDER BY tblNewspaper.NewspaperID;
5. Ensure that Row Source Type is set to Table/Query.
6. Ensure Limit To List is set to Yes.
7. Name the combo box as cboNewspaperID.
8. Save and run.
 
Back
Top