Limiting Listbox returns

[Gary]

Using Access2002, I have created a training database to
track courses employees attend. All employee data is
tracked on [EeTbl], detailed class data on [ClsTbl], and
attendance data, tracking [EeID] and [ClsID] on
[AttendTbl].

Linked to the Employee form is a secondary form with
detailed course information (name, code, hours, dates,
etc.). I have created a listbox in which I would like to
display all courses the employee has attended- but when I
create the listbox using the Wizard in Access the listbox
returns all course titles from every employee, rather than
only the courses that particular employee has attended-
which generates errors.

How can I limit the listbox to only return courses from
the selected employee (from the linked main form)?

Any assistance greatly appreciated!
Gary

 

[Guest]

You will have to modify your RecordSource for your list
box. Activate the query builder and possibly use a Query-
by-form technique or re-write the SQL by code.

--Craig