Settig Up List Box

[jgrau via AccessMonster.com]

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"

 

[Gina Whipp]

jgrau,

You will need to create a query and make that the RecordSource of the List
Box. In the query make the EmployeeID the first field and the Project the
second field. When setting the Column Widths for the List Box do 0;1. Then
Link Child Fields - Link Master Fields on the List box to the ExployeeID on
your Main form/List box.

--
Gina Whipp

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

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

 

[jgrau via AccessMonster.com]

Thank you Gina I will give this a go.

jgrau,

You will need to create a query and make that the RecordSource of the List
Box. In the query make the EmployeeID the first field and the Project the
second field. When setting the Column Widths for the List Box do 0;1. Then
Link Child Fields - Link Master Fields on the List box to the ExployeeID on
your Main form/List box.

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

[quoted text clipped - 5 lines]

"Would Deeply Appreciate Any Help"

 

[Gina Whipp]

jgrau,

You're welcome... If you have a problem, post back!

--
Gina Whipp

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

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

Thank you Gina I will give this a go.

jgrau,

You will need to create a query and make that the RecordSource of the List
Box. In the query make the EmployeeID the first field and the Project the
second field. When setting the Column Widths for the List Box do 0;1.
Then
Link Child Fields - Link Master Fields on the List box to the ExployeeID
on
your Main form/List box.

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

[quoted text clipped - 5 lines]

"Would Deeply Appreciate Any Help"