Create report from form data

I want to create a report based on a form data....this form takes user input in text fields and does some calculations based on a module...i cant just export data using the export option as it output the field names as labels which the user has to edit

most of the fields in the form are not based on a query and are not part of a table

how can i take the existing data entered in the form and output it to a report?
LVL 6
samipkAsked:
Who is Participating?
 
tbsgadiCommented:
Hi samipk,

You can put expressions in the textboxes of the report like = [Forms]![frmMain]![Text1]


Good Luck!

Gary
0
 
samipkAuthor Commented:
i have tried creating a text field on the report and setting its value to

=[Forms]![columecalc]![TotalVolume]

but it just shows #Name and doesnt work
0
 
tbsgadiCommented:
Is the form open before you open the report?
Is columecalc spelt correctly?
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
samipkAuthor Commented:
yes i have created a button inside form and after all the values are entered i press that button to open report and yes the field is spelt correctly
0
 
samipkAuthor Commented:
yes you were right the field was spelt incorrectly the solution works
0
 
tbsgadiCommented:
columecalc is the name of the form & TotalVolume is the name of the Textbox on the form?
If so can you post a screenshot of the report design
0
 
tbsgadiCommented:
I posted that before I got your comment
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.