theinviter
Registered User.
- Local time
- Today, 14:40
- Joined
- Aug 14, 2014
- Messages
- 237
Dear Guys;
Need help:
I created a form , as there is a text field will read the data from table with below code. and there is a button to open a report . so if i do the same code in report, it will take time to open .
my question is there any way that once i open the report , will get the data from the opened form instead of typing the same below code in report.
Nz(DSum("[Balance]","[MRN]","[Item Code] ='" & [Item Code] & "' AND [Location - Clinics Code] = " & [Location_Code] & " AND Year([Date_]) = 2022"),0)
Need help:
I created a form , as there is a text field will read the data from table with below code. and there is a button to open a report . so if i do the same code in report, it will take time to open .
my question is there any way that once i open the report , will get the data from the opened form instead of typing the same below code in report.
Nz(DSum("[Balance]","[MRN]","[Item Code] ='" & [Item Code] & "' AND [Location - Clinics Code] = " & [Location_Code] & " AND Year([Date_]) = 2022"),0)