Populating a List Box

J

jegrau

I am currently developing a Workload Analysis Database that tracks projects
and people assigned to them. I am trying to populate a list box which when
they go into the employee form it populates this list box called assigned
projects with all projects from the projects table assigned to the individual.
I have the name and employee number keyed to the projects table.

"Would Deeply Appreciate Any Help"


--
John E. Grau
IT Specialist
Bureau of Land Managment
Miles City Field Office
Miles City MT 59301
[email protected]
 
P

PieterLinden via AccessMonster.com

jegrau said:
I am currently developing a Workload Analysis Database that tracks projects
and people assigned to them. I am trying to populate a list box which when
they go into the employee form it populates this list box called assigned
projects with all projects from the projects table assigned to the individual.
I have the name and employee number keyed to the projects table.

"Would Deeply Appreciate Any Help"
Click to expand...
Any reason you can't just use a subform? Nice thing about it is that a
subform's data can be modified easily - and if you dont want to allow
modification, set the AllowEdits property to false.

If you want to populate the listbox with related values, then you could set
the controlsource of the listbox to a query that joins the "assignments"
table to the Projects table and returns the project names.
then you might have to requery the listbox in the OnCurrent event of the form
(Don't remember... I just don't usually use listboxes except for collecting
user selections.)
 
Top