Does Report always requery?

N

NetworkTrade

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....
 
K

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.
 
K

Ken Sheridan

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
 
N

NetworkTrade

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