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,
...
   Store_Item
   For i = 1 To 120
      RSInvD.Requery     'RSInvD is the recordset for InvoiceDetail
    Next i
   Cal_TotalAmt

 Store_Item()
   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