>>>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.