Requery?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve Warren - 12 Oct 2005 02:40 GMT

Thanks in advance.

Below is an explanation from access about requering. To me its not clear or
is it saying there is a difference between DoCmd.Requery method and Requery
method. If you could, could you show me the expression used for both. Thanks
again.

When you use the Requery action or the DoCmd.Requery method, Microsoft
Access 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.

Reply to this Message

Allen Browne - 12 Oct 2005 07:15 GMT

The Requery action is invoked in a macro. The Requery method of the DoCmd
object simulates exactly the same thing in VBA code.

Other objects also have a Requery method. Examples:
a) To requery the RecordSource for a specific form:
Forms!Customers.Requery

b) To requery the RowSource for a combo:
Me.Combo1.Requery

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thanks in advance.
>
[quoted text clipped - 8 lines]
> it. Note that the ActiveX Data Object (ADO) Requery method works the same
> way as the Access Requery method.

Reply to this Message