HI all,
My query is ,
if i insert flight no 111, it should dislpay me from and to from list box
Example, flight no 111 after presssing tab it shlould display from NYC to LON from list box/combo box

How is the flight number entered? The easiest thing to do would be to create a query that returns all your flight numbers the departure point and the destination. Base a combo box on this query with the departure/destination info as columns of the combo. Then in the after update of the combo box, you assing these values to other controls:

Me.ControlName = Me.ComboBoxName.Column(#)

HTH.