I am running this code
Code:
Private Sub rpt_criteria_go_btn_Click()
DoCmd.OpenReport "staff_login_hours", acViewReport, , staff_log_empl_num = Me.rpt_criteria_emp_id
End Sub
...and I can't figure out why the report isn't loading any records. (me.rpt_criteria_emp_id) is a field in a form that I'm using to allow the user to choose the employee that they want to pull the info for, (staff_log_empl_num) is a column in the query that the report is based on but I am getting no records. Can anyone figure this out w/ the info given????
P.S. there are records that fit the criteria. I opened the report directly and see the records.