Adding lookup to a exsisting form

  • Thread starter Thread starter Terry Cano
  • Start date Start date
T

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.....
 
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.....
Click to expand...

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.
 
Yes a Combo Box or Drop Down
menu where entries can be clicked and populate a field
Thanks
 
Yes a Combo Box or Drop Down
menu where entries can be clicked and populate a field
Thanks
Click to expand...

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
 
Back
Top