>>>>>I am incurring a "record out of range" when I evaluate the expression
>>>>>"thisform.mylistbox2.value", I think this to be an inappropriate message.
>>>>
>>>>How are you evaluating the expression?
>>>>BTW- You can make it easier for people to answer your questions by giving more details about the situation where you are experiencing a problem.
>>>
>>>Well the user has made selections from 2 listboxes, one after the other.
>>>In the 2nd listbox's click, I make the evaluation and get the error. one thing, listbox2 gets the focus before listbox1 so "?thisform.mylistbox2.value" is executed in listbox1
>>
>>Tim (new picture?)
>>
>>Does the data in Listbox2 change after the choice in Listbox1? You may be needing a requery here.
>>
>>HTH
>>Barbara
>
>Yes new photo. In the click section of said listbox I copy results to temp file and then issue a brow, then it bombs out. But if I issue do form other and do the above, it works.

Tim, every time I've gotten a "record out of range" error I've been in the wrong SELECT area. This possiblility seems to be supported by your getting the correct answer (or no error) when you approach from a different angle.

HTH
Barbara