how to make a drop down menu with many selections???

[Guest]

ok....im trying to make a simple drop down menu for building names. What i
want to avoid is to reenter the same building over and over again. Can
someone give me a simple step by step how to?
thank you in advance

 

[John Vinson]

ok....im trying to make a simple drop down menu for building names. What i
want to avoid is to reenter the same building over and over again. Can
someone give me a simple step by step how to?
thank you in advance

What's the context? Where do you want this Combo Box (the proper name
for a "dropdown") to be used?

John W. Vinson[MVP]

 

[Guest]

It sounds like you want to do this in a table. If you want to do this in a
form, let me know, 'cause the procedure is different.

In a table, you have two choices. You have to define the field as a lookup
field, then you can either enter the values you want in your list of choices,
or you can link the lookup field to a separate table where your buildings are
listed. The separate table option is easier to update. Look in Access Help
for information on lookup fields. If that doesn't help you, holler back with
another post and I'll walk you through it.

GwenH