Requery?

[Steve Warren]

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.

 

[Allen Browne]

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