Hi All,
The below command works pretty well:
DoCmd.OpenReport "Project HSE Management Report", acViewReport, , "[ProjectID] = '002'"
Unfortunately, when I replace the '002' with the actual Form Control (see below), it crashes!!!!
DoCmd.OpenReport "Project HSE Management Report", acViewReport, , "[ProjectID] =" & Me.ProjectID
What could be the problem?
The form is called PROJECTS and sits on a Navigation Control called NAVIGATION PAGE.