A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Adding lookup to a exsisting form



 
 
Thread Tools Display Modes
  #1  
Old May 18th, 2010, 01:39 AM posted to microsoft.public.access.forms
Terry Cano
external usenet poster
 
Posts: 12
Default Adding lookup to a exsisting form

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.....
  #2  
Old May 18th, 2010, 01:45 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Adding lookup to a exsisting form

On Mon, 17 May 2010 17:39:01 -0700, Terry Cano
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]
  #3  
Old May 18th, 2010, 06:42 AM posted to microsoft.public.access.forms
Terry Cano
external usenet poster
 
Posts: 12
Default Adding lookup to a exsisting form

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

  #4  
Old May 18th, 2010, 04:42 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Adding lookup to a exsisting form

On Mon, 17 May 2010 22:42:01 -0700, Terry Cano
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]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.