Open Report based on date

  • Thread starter programmingrookie
  • Start date
P

programmingrookie

I have two reports that are used for mailing labels. Before May 1 of each
year, I want to use the current address report, and after May 1 I want to use
the permanent address report. How can I code a command button to
automatically check the system date and open the appropriate report?
 
O

Ofer

use the month of the current date, if it smaller then 5 then one condition
else the second condition


If Month(Date()) < 5 then
Docmd.OpenReport "[current address report]"
Else
Docmd.OpenReport "[permanent address report]"
End If
 
Top