Hi Robin,
Get the Product_ID directly from the controlsource (table or cursor). If the control source of Product_ID is myCursor.ProductID, then you can use myCursor.ProductID to determine what value Product_Name should display in the refresh of Product_Name.
Regards,
Jim Edgar
--------------------------------------------------------------------------------
>Hi,Dear All,
> I've met a problem in grid programm. And hope could get some help from you.
> I've created a grid with some columnes, one is product_id which could be inputed by user and another column is product_name which shows the product name of the product_id. But I don't know how to write the refresh code of product_name because I can not get the right product_id from the property of grid or column. How can I do?
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.