multiple list boxes on a form to get the desired value

[shiela]

I want to have a form where a user can choose a source country and then a destination country to get a shipment rate.

 

[DougP]

And you want???<br>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???<br><br>Do these things:<br>Add two combo boxes to your form<br>1st box has normal Selection information.<br>2nd box looks at first box as follows:<br><br>SELECT DISTINCTROW Orders.OrderID, Orders.EmployeeID FROM Orders WHERE (((Orders.EmployeeID)=[Forms]![Form1]![Combo1]));<br><br>1st box has a requry in the after_update event<br><br>Private Sub Combo1_AfterUpdate()<br>&nbsp;&nbsp;&nbsp;&nbsp;Combo2.Requery<br>End Sub<br><br>OK<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.