Getting a list box to display results from a combo box 1

[relax4delicutfew]

If Ive got a combo box named, cboRoute, and it has certain values. How do I get the list box, lstCrashes, to display the query results from a query called, qryCombo1, when a value in the combo box gets selected?

Thanks!

 

[PHV]

In the AfterUpdate event procedure of cboRoute, provided that the RowSource property of lstCrashes is set to "qryCombo1", you simply add this line of code:
lstCrashes.ReQuery

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244