Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table Information on Form - No Relationship 2

Status
Not open for further replies.
Sep 12, 2006
111
US
I have a table that hold "project information"

Project Number
Project Name 1
Project Name 2
Project Street
Project City
Project State
Project Zip

I would like to have this information appear on my reports in the header. When I "Add Existing Fields" to the report it wants to create a relationship. All I need is the information to appear on my reports. Is their a way to add the informtion to the report without having it create a relationship?
 
Sorry title should read, Table information in REPORT, not form.
 
Who may use the DLookUp function in the ControlSource of a TextBox

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
How does your report know which Project to display in the header if there is no relationship? Don't you have multiple project records?

I typically use a subreport for "header" type information so I can re-use it on other reports.

Duane
Hook'D on Access
MS Access MVP
 
Just a single project record. The DLookUp worked out well.

Thank You
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top