List boxes

[Ken Fedak]

I have one combo box which lists available foreman, I then have two list boxes which list employees. The employees can be selected and move to the second list box. How do I get the list box to list only employees belonging to a certain foreman and when employees are selected have each employee as an individual record in the table.

 

[Rob.Mills]

Listboxes can be a tricky thing. They almost always require some programming. If you want the first listbox to show only employees that are related to the foreman you select in the combobox then I would base the listbox's rowsource on a parameter query that pulls the value from the combobox. Then in the After Update event of the combobox have it requery the listbox.

 

[Pat Hartman]

You will find that if you use a subform to assign workmen to formen, you won't need to do any programming.