Report pulling data from a form

B

Brian

I have a report that pulls a value from a form which is
open prior to the report opening. The form is used by the
user to enter a date. That date should appear in the
report. If you are viewing the report the value of the
form field appears on the report. However, when you print
the report you get #Name? instead of the form value. Any
idea why this is?
 
C

Carlee

That happened to me too. The cause of my problem was because the form from which the values are being pulled from was closed. Keep the form where the data is being pulled from open, but minimize it if you don't want it visible. You can then add a docmd.close line to close the form when the report is closed.

HTH
Carlee :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Creating a Chart on form from selected data in query. 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
access report 0
Form, instead of Report, Prints ??? 0
access 2010 date field 4
Adding data to MS Access from csv file 0

Top