>>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.
>
Barbara, thanks for the help. What form property could I use in the above statement? When the user clicks on his listbox selection, depending on which item he clicked, I want that dbf to open.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
