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.....

On Mon, 17 May 2010 17:39:01 -0700, Terry Cano
<(E-Mail Removed)> wrote:

>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.
--

John W. Vinson [MVP]

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

"John W. Vinson" wrote:

> On Mon, 17 May 2010 17:39:01 -0700, Terry Cano
> <(E-Mail Removed)> wrote:
>
> >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.
> --
>
> John W. Vinson [MVP]
> .
>

On Mon, 17 May 2010 22:42:01 -0700, Terry Cano
<(E-Mail Removed)> wrote:

>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/acc...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

--

John W. Vinson [MVP]