>The Value will hold the selected item's value, the controlsource is where the value came form. When a user is in the combo and they changed the selected item, the controlsource will not be updated until they leave the combo. The Value property is updated in real time as the user makes their chioces. By using teh WHEN to call teh requery and the Valkue for the WHERE clause you can have the city combo dynamically update whenever the user selects a new state. The user won't need to leave the state combo for the city combo to be updated.


Since the user can only be using one control at a time, why have the cities update each time the state changes? If they arrow down through the list of states, won't that be constantly changing the cities? Why not do it in the lost focus since the state combo would have to lose focus before the cities combo can get focus, anyway?

-Michelle