CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> CodeCharge Studio -> ASP

 dynamic listbox? (based on record, not another listbox the user clicks)

Print topic Send  topic

Author Message

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
View profile  Send private message

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.