Hi
I have two tables :
1. Employee : EmployeeID, EmployeeName ..
2. Project: ProjectID, EmployeeID, ProjectName, ElementName , WBS
TextBox (EmployeeID) : displays employee ID (Populates from another list Box selection)
List Box (ListProject) : displays ProjectName, ElementName, WBS
Once the EmployeeID populated from another list Box
I want the ListProject should populate the list of projects associated with that employee ID.
Could you please help me with this.
I tried placing this query in the after update function in the text box:
Private Sub EmployeeID_AfterUpdate()
Dim SQL As String
SQL = "Select ElementName,ProjectName,WBS From[Project] where [EmployeeID] = " & Me![EmployeeID].Value
Me![ListProject].RowSource = SQL
Me![ListProject].Requery
End Sub
And added the rowsource of the List box as this :
to the employee ID: In criteria:
[Forms]![formname]![EmployeeID]
But the values are not populating.
Bookmarks