Question on Requery 
Author Message
 Question on Requery

The following is my coding....
Question is after Insertion of a record, it does not take effect even the
Requery is performed.
Can anyone help please?

In Main logic,
   For i = 1 To 120
      RSInvD.Requery     'RSInvD is the recordset for InvoiceDetail
    Next i

   Dim cmdChange1 As ADODB.Command
   Dim strSQL As String
      strSQL = "INSERT INTO InvoiceDetail VALUES (.......)"
      cmdChange1.CommandText = strSQL
      cmdChange1.Execute adAffectAll

Sun, 24 Oct 2004 23:40:22 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Record Lock/Requery Question.

2. Record Lock/Requery Question.

3. Question about ADO Requery

4. *Requery* questions

5. Street.requery or DoCmd.Requery Street - Is one faster?

6. Requery combo on Main form requeries all Child/Master linked subforms - is this a new bug?

7. Requery a subforms recordsource

8. requery current record on the form???

9. requery subform doesn't work

10. control Requery

11. Requery

12. Requery Method


Powered by phpBB® Forum Software