could you be caught by a onerror routine?



>Didn't work.
>
>I've always used that line without a space and it's always worked just fine.
>
>But even when I change the line:
>
>sele(returnto)
>
>to:
>
>sele fingoods
>
>it still doesn't work. For whatever reason, after closing the browse window that contains the SQL cursor results, it seems to jump over anything else and leaves the cursor as the active work area.
>
>
>>>Hi all,
>>>
>>>In a Finished Goods form, I have a command button set up to allow the user to browse all open orders that we have on file for the part number they're currently viewing. The command button's click event contains the following code:
>>>
>>>-----
>>>returnto=sele()
>>>seeker=fingoods.part_no
>>>
>>>sele ord_line.order_no, ord_head.cust_no, customer.cust_name, ord_head.cust_po, ord_line.quantity, ord_line.ship_date;
>>> from ord_line, ord_head, customer;
>>> where ord_line.order_no=ord_head.order_no;
>>> and ord_head.cust_no=customer.cust_no;
>>> and ord_line.usmc_part=seeker;
>>> order by ord_line.order_no;
>>> into curs temp
>>>
>>>sele temp
>>>brow title "Open Orders for this Part Number"
>>>use
>>>
>>>sele(returnto)
>>
>>The last line is where you got it wrong. Instead of
>>
>>select (returnto)
>>
>>it's doing
>>
>>select(returnto)
>>
>>which is actually a function returning the workarea of the alias contained in the returnto variable. Just insert a space to make it a command.