Page Numbers appear as #Name?

[David Ball]

Hi,

I have a report that has the page number displayed in the footer. This was set up using the Page Number icon under Design, Header/Footer.
Everytime I open the database and run the report the page number appears as #Name?
If I use the Page Numbers icon to set it up again it works. It continues to work until I close the database. Next time I open the database and run the report I get #Name? again.
I think it has only been happening since I added some DLookups to the report.
Why is this happening and how can I fix it?
Thanks very much

Dave

 

[Ranman256]

There should be no reason to run a Dlookup in a report.
All the values should come from the query.
but this shouldnt affect page #.

 

[GinaWhipp]

Sometimes, if there is an error in the Report it can cause that. So, the first thing to confirm is are all your DLookup()'s working? Also, do you have any other calculations on the Report? Are they working?