>Both the combo data box and the list box are populated by sql statements in their respective adodc's. When I try to retype the sql statement that populates the listbox in the change event for the combo data box, I get an error message that seems to indicate that the system is expecting a case statement.
Show the code that you have in your change event.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com