I have a form with 2 comboboxes. The first contains a list of agencies. The user picks an agency and requeries the second combobox from the contact table for the contacts in the selected agency.

I have a separate find form where the user can pick a specific record containing an agency key.

When the user picks a record with an agency that has, let's say, 5 contacts. The agency combo box displays the correct agency, the contact combobox is blank. Tabbing through the contact and then shift-tabbing back displays the correct contact. Problem 1.

After displaying the record with the 5th contact selected and choosing a different record to display, if the agency's contact list is only 2 long, I get a record out of range error. Problem 2. I have requeried contact before the error and the refresh seems to cause the problem. The control source for the contact combo is the parent record contact key (as opposed to something in the agency view).

Any help will be appreciated.

C Qualset