Add the CompanyName field to your form.  If it is not already a combo
box, then change it to one by using the right click menu.
Then open the properties window to your combobox.
1.  Row Source Type should be Table/Query
2. Row Source should be the name of your table.
3. Column Count should be 1
4. Bound Column should be 1
5. Limit to List should be Yes, unless you are going to allow users to
type in a name that will not be listed in the table. 

Dawn Crosier
Application Specialist
"Education Lasts a Lifetime"
 
This message was posted to a newsgroup.  Please post replies and
questions to the group so that others can learn as well.
 

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of ltportellar
Sent: Saturday, March 18, 2006 12:51 AM
To: [email protected]
Subject: [ms_access] populating field of a form using a drop down menu

I want to design a form with a field named CompanyName and to populate
that field I would like to have a drop down list with the names in an
existing table. How can I do it? thank you


 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/ms_access/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Reply via email to