open report data from form (1 Viewer)

theinviter

Registered User.
Local time
Today, 08:52
Joined
Aug 14, 2014
Messages
168
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)
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:52
Joined
May 7, 2009
Messages
16,419
you need to Close the Report and Re-Open it so that your Parameters will get updated.
 

theinviter

Registered User.
Local time
Today, 08:52
Joined
Aug 14, 2014
Messages
168
you need to Close the Report and Re-Open it so that your Parameters will get updated.
i did that but the issue i dont want to write the code ,as it take time to open. i want the report get the value from opened form. but it will repeated for all field as its different.
 

Attachments

  • ssss.png
    ssss.png
    18.1 KB · Views: 84

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:52
Joined
May 7, 2009
Messages
16,419
create a Query and create the Calculated column in your Query.
use the Query as the RecordSource of your Report.
 

theinviter

Registered User.
Local time
Today, 08:52
Joined
Aug 14, 2014
Messages
168
create a Query and create the Calculated column in your Query.
use the Query as the RecordSource of your Report.
i can do that , but the issue it take long time to open especially when the file shared . as i have more that 10 thousand record in query.
 

Users who are viewing this thread

Top Bottom