I feel like I should know how to do this but it seems to be escaping me at the moment.
I have an object, we'll call it assignment. It holds the following
ID, int - Unique Identifier for the the object
MemoID, str - The memo for which it is an assignment for
ResponsibleStaff, int - Staff responsible for the assignment
Due Date, date - Date the assignment is due
completedby, int - Who completed the assignment
completedDate - When the assignment is completed.
I want to be able to reuse a form, well call it fromAssignment. This form can be launched any of two different ways.
1. Click on a list box of assignments, a temp assignment object is created the information for the respective assignment is passed to this object
-the form is launched and the information from the assignment object is passed to the form
2. Click on a add Assignment button and a blank form is opened.
My problem is that I want to be able to have the Responsible Staff and (if any) the completed by staff name displayed in the combo box.
The combo box is set to a value list and has a dynamically defined rowsource for the combobox. It is two columns, the first column is hidden. It stores the EmpID, the second one stores User Fname & " " & lname.
I want to look through each value in the combo box. where tempg.completedby (returns an int) matches the respective row. Have that be the selected row.
I hope this makes sense. Any help anyone can provide is greatly appreciated.
you can reply by posting here or my email is below
mweyland @ mnqio dot sdps dot org