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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Field works ONLY in report header?

Status
Not open for further replies.

joebloeonthego

Technical User
Mar 7, 2003
212
CA
Hello, I have a report called from a search form with 20 or so search fields (so they can filter by any field). The report prints all the records and at the top shows any date or cost filters that were used, ie: date>, date<, cost>, cost< (there's 6 in total) and I just reference the textbox on the search form and it works great.
It works great ONLY if they're in the report header. If i move them to the page footer, or page header (where management now wants them) they all show up as NAME?.

I must be missing something?
 
Can you explain how you are populating the textboxes with the values. Are you just referencing a form value in the Control Source for your report Textbox with something like

Code:
=Forms!Form1!Text0

That should work in both the Report Header and Page Header. You might try referencing the textbox in your Report header with the textbox in your Page Header. And then just set the visible property for the textbox in your Report header to No.

Paul
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top