Does Report always requery?

[Guest]

When a Report is designed/sourced from a query;

When you newly open that Report - does it inherently re-run the query?...so
that it is always the most current info....

 

[Ken Snell \(MVP\)]

When you open a report, the report runs the query that is the report's
Recordsource, thereby returning all records that meet the query's
requirements at that time.

 

[Guest]

Yes, but remember that any unsaved data currently showing in a form won't be
reflected in the query, and hence in the report, so if opening a report from
a button on a bound form make sure the current record is saved first e.g. to
print the current record

Dim strCriteria As String

strCriteria = "MyID = " & Me.MyID

RunCommand acCmdSaveRecord
DoCmd.OpenReport "MyReport", WhereCondition:=strCriteria

Ken Sheridan
Stafford, England

 

[Guest]

thanks both..........have always thought so but surprisingly couldn't locate
a simple discussion & answer to that question in my reference books....