hi,
i want to view all programs for a coordinator to appear in a listbox with other information such as year..
i wrote this command
Dim stringCo as string
StringCo = "SELECT [CoordinatorID],[year],[nameÌ],[Co_name]" & "FROM Qco" & _
"WHERE [CoordinatorID] = Me.CoordinatorID.Text"
CoPro.RowSource = StringCo
it works fine for all records but when i run the condition (
& _
"WHERE [CoordinatorID] = Me.CoordinatorID.Text")
it gives a blank list box
any ideas?
i want to view all programs for a coordinator to appear in a listbox with other information such as year..
i wrote this command
Dim stringCo as string
StringCo = "SELECT [CoordinatorID],[year],[nameÌ],[Co_name]" & "FROM Qco" & _
"WHERE [CoordinatorID] = Me.CoordinatorID.Text"
CoPro.RowSource = StringCo
it works fine for all records but when i run the condition (
& _
"WHERE [CoordinatorID] = Me.CoordinatorID.Text")
it gives a blank list box
any ideas?