pull down menus

S

Steve

1. You need an employee table with fields:
EmployeeID
EmployeeFirstName
EmployeeLastName
2. Create a query with the fields:
EmployeeID
EmployeeName = EmployeeLastName & ", " & EmployeeFirstName
3. Sort ascending on EmployeeName
4. Add a combobox from the toolbox to your subform
5. Select the combobox and open Properties
6. Under the Data tab, set
a) Rowsource to your query
b) bound column to 1
7. Under the Format tab, set
a) Column Count to 2
b) Column Width to 0;1.5
8. Close Properties

Steve
(e-mail address removed)
 
G

Gina Whipp

smsgroi,

Do you mean a combo box? That can be added while in design view of the form
using the wizard. Which, by the way, you were told in your previous
posting. So I am wondering, are you unfamilar with combo boxes? OR is that
not what you meant by pull down menu?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top