Adding lookup to a exsisting form

[Terry Cano]

How can I add a lookup to a form?
Clicking design and going to Data gives me options for functions etc...but
not for lookup.....

 

[John W. Vinson]

How can I add a lookup to a form?
Clicking design and going to Data gives me options for functions etc...but
not for lookup.....

A "Lookup" is also called a "Combo Box", you might find it easier using that
term.

You're not saying what you want to look up from where, so it's a bit hard to
be specific, but check out the "Combo Box" wizard on the toolbar/ribbon.

 

[Terry Cano]

Yes a Combo Box or Drop Down
menu where entries can be clicked and populate a field
Thanks

 

[John W. Vinson]

Yes a Combo Box or Drop Down
menu where entries can be clicked and populate a field
Thanks

Open the form in design view.
Be sure the Toolbox is open.
Be sure the magic wand icon is selected.
Select the Combo Box tool.
Outline the desired location on the form of the combo box.
Follow the prompts.

You may want to look at some of the tutorials here to get started:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials