If Me.ProjectID is "002", then try this line:
DoCmd.OpenReport "Project HSE Management Report", acViewReport, , "[ProjectID] = '" & Me.ProjectID & "'"
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
If Me.ProjectID is "002", then try this line:
DoCmd.OpenReport "Project HSE Management Report", acViewReport, , "[ProjectID] = '" & Me.ProjectID & "'"