Prev: Access runs slow under Windows 7
Next: Another cascading combo challenge
From: Terry Cano on 17 May 2010 20:39
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.....
From: John W. Vinson on 17 May 2010 20:45
On Mon, 17 May 2010 17:39:01 -0700, Terry Cano
<TerryCano(a)discussions.microsoft.com> 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]
From: Terry Cano on 18 May 2010 01:42
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
> <TerryCano(a)discussions.microsoft.com> 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]
> .
>
From: John W. Vinson on 18 May 2010 11:42
On Mon, 17 May 2010 22:42:01 -0700, Terry Cano
<TerryCano(a)discussions.microsoft.com> 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/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

--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Access runs slow under Windows 7
Next: Another cascading combo challenge