C
channell
Ok, I have read and I am still a bit confused... I think I am close, but I
need just a bit of assistance. Thank you very much in advance!
I have a list box poulated with employees. It only shows their names, but
there are really three columns: [Employee ID], [POSITION ID], [EMPLOYEE NAME]
Now, in the cbo box above it, I have it populated with work positions
[POSITION ID].
Here is the code I have right now, maybe I am doing something wrong, please
help. Thank you!!
Private Sub Combo55_AfterUpdate()
Dim strSQL As String
strSQL = "Select " & Me!Combo55
strSQL = strSQL & "POSITION ID"
Me!ListEmployees1.RowSourceType = "Table/Query"
Me!ListEmployees1.RowSource = strSQL
End Sub
I select a position in my cbo box, and the list box goes blank. Thanks!
-Scott Channell
need just a bit of assistance. Thank you very much in advance!
I have a list box poulated with employees. It only shows their names, but
there are really three columns: [Employee ID], [POSITION ID], [EMPLOYEE NAME]
Now, in the cbo box above it, I have it populated with work positions
[POSITION ID].
Here is the code I have right now, maybe I am doing something wrong, please
help. Thank you!!
Private Sub Combo55_AfterUpdate()
Dim strSQL As String
strSQL = "Select " & Me!Combo55
strSQL = strSQL & "POSITION ID"
Me!ListEmployees1.RowSourceType = "Table/Query"
Me!ListEmployees1.RowSource = strSQL
End Sub
I select a position in my cbo box, and the list box goes blank. Thanks!
-Scott Channell