Forget DTC's, either use server-side JavaScript or ASP. I found the
event-handling and other issues to be illogical and atrocious with 
DTC's.
Dirk

> -----Urspr=FCngliche Nachricht-----
> Von:	Rich Cole [SMTP:8r8251@e...]
> Gesendet am:	Mittwoch, 7. Februar 2001 18:01
> An:	Interdev_Programming
> Betreff:	Listbox DTC
>
> I'm using a listbox dtc to update an asp page.  The listbox's 
onchange()
> event runs two subroutines.  The first subroutine is to diplay the 
DTC and
> the second subroutine displays a table.  The value of the DTC is 
stored in
> a session variable (and captured in the listbox DTC's onchange() 
event)
> and is used as part of the SQL statement's WHERE clause in the second
> subroutine.  The table is then created in the second subroutine using 
the
> new SQL statment.
>
> When the asp page opens, a default SQL statement is used and both
> subroutines are called and the DTC and table are displayed.  The user 
can
> now click the Listbox DTC and choose a new value.  The listbox 
onchange()
> event fires and calls both subroutines again.
>
> Here's my problem:  This process works the first time the user 
selects a
> new value in the Listbox DTC but fails everytime thereafter.  What 
could
> be the problem?
>
> Rich