pull down menus

[smsgroi]

how do i get pull down menus in a subform of employee names

 

[golfinray]

Use a combo box.

 

[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)

 

[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