
January 25th, 2004, 07:38 AM
|
|
Registered User
|
|
Join Date: Jan 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
create form based on selection in list box
I have a table with fields : PersonID, courseID and status. This indicating for each person which courses have been assigned to him and the status of the course (cancelled, completed, started, assigned). So each personID has one or more records in the table.
I want a form to display for a given person all yet to complete courses. For this I have made a parameter query, and based a form on that. When opening that form, the user is prompted for the personID, and all courses with status not completed or shown.
I have made a second form, with an unbound list box containing all personIDs from the table. On this second form also a command button which opens the described form based on the parameter query.
So now I need to make the parameter query use the personID selected in the listbox on the other form, instead of prompting the user for that personID once again.
Hope this is clear ? And hope even more that someone can tell me how to do this ?
Thx.
|