Report pulling data from a form

  • Thread starter Thread starter Brian
  • Start date Start date
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?
 
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 :)
 
Back
Top