CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> ASP

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

Print topic Send  topic

Author Message
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
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 http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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