DH Templates

How do I add information from a form and display it on a report in Microsoft Access 2010?

I am using Microsoft Access 2010 and I am new to this software. I have got the template from the Microsoft website that is why I have done most of it. What I want to do is there is a form to enter customer details, and I want to take information from one of the fields and show it on the quote / invoice report which will be produced at the end. This has been done in the template for the other fields as I enter information such as customer name it is displayed on the report. I would like to do the same with another field however, I am unable to work out how this could be done. Any of your help is appreciated. I have tried using the expression builder and choosing the field however, this comes up when I view the report, #Name? If you could please tell me how this can be done then your help is appreciated. Thank You for you help This is the template that I downloaded and used: http://office.microsoft.com/en-us/templates/results.aspx?qu=invoice&av=my#ai:TC102489834|

Public Comments

1. If you used the expression builder than this is what your field should read: =[Forms]![FormName]![FieldName] this will reference what is in the field, the reason that you are getting #Name is because Access can't locate the field you are referencing, the form is closed...try opening the form and then reopening the report and you will see it will work. What exactly are you trying to do?