Larry & Charles, Thanks for your assistance - I now have this working using the code as per Larry's email. I appreciate your help.
Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Wednesday, 23 February 2005 2:33 p.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Editing a table from a form while editing a table from a form > Is there a way to disconnect the first form > from the table, allow the editing to take place in the second version of it, > and then return to the original form ? Do this: PROPERTY TABLE TableName POST EDIT USING SecondForm WHERE. . . PROPERTY TABLE TableName REFRESH The call to POST will make certain that the current record is pushed from the form to the table on disk. The EDIT USING runs your second form. The REFRESH reloads all the rows on the first form to show any changes you made on the second form. Aternatively, my preferred approach is to show the data on the first form in a variable lookup list box and then edit the data on a separate form, followed by PROPERTY listBoxControl REFRESHLIST TRUE -- it removes all locking and buffering issues from the equation. -- Larry -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.306 / Virus Database: 266.4.0 - Release Date: 22/02/2005
