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

>Ok you're right, I have a statment like this:
>
>With Thisform.myListbox2
> .RowSourceType=2
> .RowSource=""
> .rowsource= 'WoffICE'
> *.Requery
>Endwith
>and on the click section I open another file and ,thus, the error. What is a good way out of that?

Tim, going on the Belt & Suspenders method of programming, try storing the selected area to a Form property. Set it to the correct value for the listbox in the WHEN or GOTFOCUS method, re-set to your 'main' table in the LOSTFOCUS method. That way whatever the active area is when you click on the listbox it will refresh with the correct area.

HTH
Barbara