Dependent values

Question:
I want to create a list box that will contain values based on the value ofanother list box. How can I accomplish this?

Answer:
A list box is populated whenever the Translation property for thelist box is set. To populate a list box based on the value of another listbox, set the Translation property of the second list box in thePostChange() method of the first list box.

If the first list box is called lstSource, and the second iscalled lstPopulate, the lstSource box contains adepartment number, lstPopulate contains the NAME and ID ofemployees of the selected department and the Datatype of the two listboxes is “String,” the code in the PostChange() method oflstSource would read:

lstPopulate.Translation = “= SELECT NAME, ID FROM EMPLOYEE WHERE DEPT = ‘” & &        lstSource.Value & “‘”

Notice that you must insert the Value of the lstSourcelist box in single quotes, since the SQL statement will need the actualvalue rather than a bind variable.

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.

See also  Five Early Architecture Decisions That Quietly Get Expensive

Related Posts

• Garmin Instinct 2S Solar discounted 45% in Australia
• Reading Text from an Image in C# Using Tessaract.Net SDK
• Connect to a Database in Spring Boot
• Google’s focus shift impacts AI innovation
• Using FOR XML PATH and STUFF SQL String Concatenation