C
carriey
I don't use a lot of Macros but what I have built is a little macro so that
when the user is on the main form for the current employee and they hit
print, it will automatically print the summary report of that employee. It
works great!
Run Command = SaveRecord
OpenReport View = Print and then the where condition is
[Tbl_Employees]![Employee_ID]=[Forms]![Frm_Main]![Employee_ID]
The problem is that the user needs to be able to select the dates of
employee pay data to print. I built an unbound form for the user to enter a
Start and End Date and then in my query I entered the Date Parameters:
Between [Forms]![Frm_Dates]![Start_Date] And [Forms]![Frm_Dates]![End_Date]
I have tried adding into my macro to OpenForm before OpenReport but it still
prints the report right away so I think that I am missing a step in my macro.
Can someone help me? Please and Thank you!
when the user is on the main form for the current employee and they hit
print, it will automatically print the summary report of that employee. It
works great!
Run Command = SaveRecord
OpenReport View = Print and then the where condition is
[Tbl_Employees]![Employee_ID]=[Forms]![Frm_Main]![Employee_ID]
The problem is that the user needs to be able to select the dates of
employee pay data to print. I built an unbound form for the user to enter a
Start and End Date and then in my query I entered the Date Parameters:
Between [Forms]![Frm_Dates]![Start_Date] And [Forms]![Frm_Dates]![End_Date]
I have tried adding into my macro to OpenForm before OpenReport but it still
prints the report right away so I think that I am missing a step in my macro.
Can someone help me? Please and Thank you!