General information
Category:
Forms & Form designer
Title:
After query, can't reselect original table
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)
-----
It seems to work fine (I'm seeing the browse window with the open orders), but it doesn't return to the original table. I've got FINGOODS open, and that's the table that's selected when the button is clicked. But when I hit Escape to close the browse window, for whatever reason it's not selecting FINGOODS again. I know this because I'm receiving error messages, and when I suspend the program to see what's up, the cursor TEMP is still the active work area.
Any ideas?
Thanks very much!
John
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only