multiple list boxes on a form to get the desired value multiple list boxes on a form to get the desired value shiela (Programmer) (OP) 19 Jul 00 13:02 I want to have a form where a user can choose a source country and then a destination country to get a shipment rate. RE: multiple list boxes on a form to get the desired value DougP (MIS) 19 Jul 00 18:36 And you want???I suppose your missing information is that when a user picks something from one combo Box that the results of that narrow down a selection in a second combo box???Do these things:Add two combo boxes to your form1st box has normal Selection information.2nd box looks at first box as follows:SELECT DISTINCTROW Orders.OrderID, Orders.EmployeeID FROM Orders WHERE (((Orders.EmployeeID)=[Forms]![Form1]![Combo1]));1st box has a requry in the after_update eventPrivate Sub Combo1_AfterUpdate() Combo2.RequeryEnd SubOK DougP firstname.lastname@example.org Ask me how Bar-codes can help you be more productive.