dbrucemoore
Posts: 3
|
Posted: 09/15/2010, 5:08 PM |
|
I have a recordset that returns 3 records. The field "session_number" contains "1", "2", and "3" respectively.
I have a listbox (course_id) in a grid which needs to filter it's contents based on session_number.
I use the following code:
Function qryCourse_selection_course_id_DataSource_BeforeBuildSelect(Sender)
With qryCourse_selection
.course_id.datasource.where = "Session_number=" & .session_number.value
.Label1.value = "*" & .session_number.value & "*"
End With
'End Custom Code
Unfortunately, the session_number.value seems to take the value from the first record and doesn't change for subsequent records (The label.value code is showing me the value staying at "1")
_________________
D. Bruce Moore |
|
|
|
|