You guys must be psychic! I have been struggling with this for a few days and the code below does exactly what I was attemping to do. I am just out of room on a form and heve several buttons to add information to several different tables, including the current driving table. This does the tricksuperbly without all the weird update messages.....
I love this forum....
Thanks
Bob C.
| Lawrence Lustig <[EMAIL PROTECTED]>
Sent by: [email protected] 02/22/2005 08:32 PM
|
|
> 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
