cktcPeterson
Member
- Local time
- Today, 10:18
- Joined
- Mar 23, 2022
- Messages
- 73
I have many open reports from forms, but for some reason, this one is not being friendly.
I have a form
frmProviderStatus
Default View: Continuous
Query: qryRequested Course_Crosstab
On field [Requested Provider] I have an on double click to open a report
Report Name
Provider Details
When I double-click on Requested Provider, I want it to open the report to filter only that provider.
The report opens fine.
This is what I have.
In the where part I have "[Requested Provider] = ' " & [Requested Provider] & " ' "
I have a screenshot of my query. I believe my problem is with the crosstab.
I have a form
frmProviderStatus
Default View: Continuous
Query: qryRequested Course_Crosstab
On field [Requested Provider] I have an on double click to open a report
Report Name
Provider Details
When I double-click on Requested Provider, I want it to open the report to filter only that provider.
The report opens fine.
This is what I have.
In the where part I have "[Requested Provider] = ' " & [Requested Provider] & " ' "
I have a screenshot of my query. I believe my problem is with the crosstab.