I currently have a form that I select a customer from a "Costomer" dropdown box. In order to then have only the items that that customer sells in the "Items" dropdown box, I wrote a query that saves the form, closes the form then opens the form back to that record. It then runs a query with the result being the only items available in the "Items" dropdown box are those that correspond with the "Customer" selected. There has to be a better way to do this. What can I do?