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.

I do not follow the part about the 'drop down box on the form' but if you have the criteria of the query that is the Row Source for your Contacts comb box correct it should work. Here is an article that may prove helpful.

hth,
Jack

Edited by: Jack Cowley on 08.25.04.