Requery methods explanation please

[matt beamish]

Ive just read this on [URL="http://office.microsoft.com/en-us/access/HA012262761033.aspx"/URL]

If you want to requery a control that isn't on the active object, you must use the Requery method in a Visual Basic for Applications (VBA) module, not the Requery action or its corresponding Requery method of the DoCmd object. The Requery method in VBA is faster than the Requery action or the DoCmd.Requery method. In addition, when you use the Requery action or the DoCmd.Requery method, Microsoft Office Access 2007 closes the query and reloads it from the database, but when you use the Requery method, Access reruns the query without closing and reloading it. Note that the ActiveX Data Object (ADO) Requery method works the same way as the Access Requery method.

Can anyone explain to me in very simple language, the difference between

Requery method in VBA

and

DoCmd.Requery method

?
Thanks.
Im using 2003, and trying to find a method to Update a Main Form on which lie various DLookup and DSum Text Boxes, after inputs on a SubForm. I have tried running Macros but get error messages, and have tried running Code and also got error messages.
Thanks
Matt

 

[ajetrumpet]

Like in the help menu, The Requery Method refers exactly to the command that you use. That is just the terminology that they use to refer to the Visual Basic language command syntax that is used to carry it out.

Thus, The Requery Method = Docmd.Requery

 

[caroleesuserid]

But the reference quoted above specifies:

you must use the Requery method in a Visual Basic for Applications (VBA) module, not the Requery action or its corresponding Requery method of the DoCmd object

So the reply seems to be in error, right?

Thanks!
Carolee