Access Report 2007 - Needs User Input

[b0bb0]

Hi,
I have just upgraded an access 2003 database to 2007 and there is a problem I cannot fathom.
I have a report that when it is run asks the user to input a reference number in a dialog box, simple, and it prints that number on the report. All it needed in 2003 was a text field with a control source [Ref No], and it did the job. But in 2007 it doesnt work and outputs #Error.
This is really doing my head in because I know it must be a simple fix, but if you dont know, you dont know!
Thanks for any help......

 

[dhookom]

No record sources you can share? If you are using a parameter query, consider reading faq701-6763.

Duane
Hook'D on Access
MS Access MVP