If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Updating Form==Query==Report
I have a date form. It has 2 text boxes that pass starting and ending dates
to a query to pull appts from that time period. If the report is left open and the dates change in the date from, I have to manually refresh the report. Is there a way that when I click off of the 2nd text box (ending date on date form) that the data updates when I click back on the open report that it all updates (Rpt.GetFocus = event) perhaps? The reason I ask is that the reports are pulled up evey hour and the operators would like the already open report to update once the form gets focus. This is probably not the right method, so i am asking for any offered solutions. Thanks for all help! Dan |
#2
|
|||
|
|||
Updating Form==Query==Report
I don’t think you can refresh a report that is already open (I might be
wrong, but have never thought of a report as a live object) With a form you just use the requery command, but an open report is a snapshot of the data at the time the report was run. You may want to attempt Reports![MyReportName].requery "Dan" wrote in message ... I have a date form. It has 2 text boxes that pass starting and ending dates to a query to pull appts from that time period. If the report is left open and the dates change in the date from, I have to manually refresh the report. Is there a way that when I click off of the 2nd text box (ending date on date form) that the data updates when I click back on the open report that it all updates (Rpt.GetFocus = event) perhaps? The reason I ask is that the reports are pulled up evey hour and the operators would like the already open report to update once the form gets focus. This is probably not the right method, so i am asking for any offered solutions. Thanks for all help! Dan |
#3
|
|||
|
|||
Updating Form==Query==Report
Andre wrote:
I don’t think you can refresh a report that is already open (I might be wrong, but have never thought of a report as a live object) With a form you just use the requery command, but an open report is a snapshot of the data at the time the report was run. You may want to attempt Reports![MyReportName].requery FYI, I haven't tried Requery, but I have a few reports that I "refresh" or whatever on the fly by changing either the report's Filter or OrderBy property. Either of those appears to cause the report to start over with its Open event where you can use code to change all kinds of things (e.g. the report's RecordSource, controls' properties including ControlSource, Sorting and Grouping entries, etc. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|