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> 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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.