I commented them out and no difference. Did you say trans should be open before the listbox instantiates.? If I remove the listbox, the problem goes away so that tells me something.The listbox has referneces to trans in its click method.
>I think your problem is there. You are closing Trans. What happens if you comment out the lines
>
>use trans excl
>zap
>
>
>>>The lostfocus won't be the problem in this case. Make sure table1 is open before the listbox instantiates.
>>
>>This prob still plagues me:
>>In the form's init I have:
>>sele 10
>>use trans excl
>>zap
>>In the lostbox rowsource I have:
>>select price,quantity,noun,detail from trans INTO CURS PTEMP
>>and the rowsource type=3
>>and still "Cannot access selected table"
>>
>>>
>>>
>>>
>>>>
>>>>
>>>>>>Hello, I keep getting "Cannot access the selected table" when my form starts. I can hit ok to continue normally, but the error seem untracable, of which I am trying to do. Any help, thanks.
>>>>>
>>>>>
>>>>>Do you have a control source that isn't open? How about the record source for a combo or list box?
"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."