I fixed it!

Views and aliases. The view defining the contacts list had to be requeried THEN THE COMBOBOX had to be requeried and then a refresh of the combobox. All of this happening when the agency value is the new parent's value and not the old.

Thank you for your kind input.

Cheryl Qualset

>>>>>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
>>>>
>>>>Record out of range is being triggered by the ff.:
>>>>
>>>>1. possibility that index is corrupt.
>>>>2. using GOTO N where N is out of range.
>>>>3. using SKIP N where N is out of range (EOF / BOF has been encountered).
>>>
>>>
>>>Another possible reason is #(253 + 256n) record will known bugs error!!
>>>
>>>Because the error will cause Serious program error and crash at once every you have add error handling to catch the error!! >_<'
>>
>>
>>Actually, 'Record out of range' returns error no. 5.
>
>Yes, it is error #5. It is definitely trying to move to a record past EOF.
>
>The combobox seems to have a pointer to a record in the last version of the record set that doesn't get reset when the view is requeried. I have tried changing the control source to blanks before requerying, setting the listindex to 0 or 1 before requerying, doing a refresh before and after these things,.... SQL or Alias rowsource type makes no difference that I have found yet. I am very frustrated.
>
>Cheryl