Dropdown box question Pleeease Help me.

[bigfoot]

OK, so I know this is a stupid question, so here go's...

What event do you use for a dropdown box to know the user has selected somthing? When my user chooses from a list of agencies, then I want to update another list with a query consisting of what they picked in the dropdown list.
BTW: I have it set up as a list only , they can't type anything in so I can't use the changed event.
Not lost focus either.

Thanks Gary

 

[Ruairi]

i use the click event of combo boxes to detect a change. In many cases i am using it to do exactly the same thing you are talking about doing, load one combo depending on the selected item in another combo.

Ruairi
ruairi@logsoftware.com
Experienced with:

VB6, SQL Server, QBASIC, C(unix), MS Office VBA solutions

ALSO: Machine Control/Automation using GE and Omron PLC's and HMI(human machine interface) for industrial applications