From: crsoft@mail.dk   
      
   Hi   
      
   Try to open the recordset and close it again BEFORE you run the report.   
      
   Dim myset as Recordset   
   StrSql="Select * from ... ;"   
   Set myset = mydb.OprenRecordset(StrSql,dbOpenSnapshot,dbReadOnly)   
   myset.close   
   set myset = Nothing   
      
   Svend   
   DK   
      
   "Red Hammer"  skrev i en meddelelse   
   news:43922d63@clear.net.nz...   
   > Hi, I have a report that I used the data designer to create and what   
   happens   
   > is that it does not update until the application is closed and opened   
   again.   
   > For example, you can enter a new record and then open the report and it   
   will   
   > not show the new record until the application is closed and started up   
   > again. Anybody got any ideas how I can make the report update immediately?   
   >   
   > Thanks for any help you can give.   
   >   
   > Weblog: http://decentre.blogspot.com   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)