On Fri, 16 Apr 2010 07:24:03 -0700, Brian T
wrote:

John,

I am using the form to create a report (which is a form letter) and I want
the project name to show up in the report and I can't fiugre out how to get
it in there.

Base the Report, not on your table, but on a Query joining your table to the
Projects table. Include the ProjectName from the Projects table on the report.
If you're assuming that a report must be based on a table containing all the
fields to be printed, revise that assumption - the vast bulk of reports will
be based on multitable queries.
--

John W. Vinson [MVP]