I am doing a SQL-INSERT into a table with buffering off via a save button on page1. Both the table and the view are in the DE. In the activate of page2 I have the following code:

WITH ThisForm.PageFrame1.Page2
  IF REQUERY("HeatView") <> 1
    =MESSAGEBOX("Records added may not show up";
      +CHR(13)+"in the grid due to Requery Failure";
      +CHR(13)+"Try reloading this form.",0,"REQUERY STATUS")
  ENDIF
ENDWITH
ThisForm.Refresh()
<\pre>

The grid on page2 is based on the view HeatView. It does not show the inserted item from the INSERT INTO... until I close the form down and reload the form.

What am I missing???

Thanks