• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Developing Multiuser Applications > Using Code to Refresh or Requery

Using Code to Refresh or Requery

In this section, you'll see how to requery by using code. The Requery method makes sure that the user gets to see any changes to existing records as well as any added records. It also ensures that deleted records are removed from the recordset. It's easiest to understand the Requery method by looking at the data underlying a form:

Private Sub cmdRequery_Click()
   If Me.RecordsetClone.Restartable Then
      Me.RecordsetClone.Requery
   Else
      MsgBox "Requery Method Not Supported on this Recordset"
   End If
End Sub


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint