I have created a form to make a job number for new projects. The job number field is an auto number field. The next field is the customer field, it is a combo box bound by the customer id. The next field is the contact field. I would like to narrow the selection of contacts to the contacts that are associated with the customer that has been selected. I created a query that selects the contacts for the customer id on the form and i have used it as my data source for the contact combo box. For some reason if i run the query it selects the right contacts but if i hit the arrow on the drop down box on the form it selects a different group of contacts.
Do i need to run the query prior to entering the contact field. Please help.