>My form is using Private Data Sesstion
>(1)I create a stockview (stocktable)
>(2)In the form I can query the correct stockview
>(3)However,when I amend the record in the stock table (by running =tableupdate(1,..
>t.,"stocktable") .After Query again , It shows the old record
>(4) I need to quit the form and run query to get the correct result.
>How can I refresh the view ,after I update the table ?
>Please help.
REQUERY([YourView])
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.