Access 2007

[Roger Bell]

I have designed a data Base in access 2003, and it basically works in Access
2007 with a a bit of tweaking.
The trouble is that some reports now ask for "A parameter value" eg:
'Lastname'. This field is not in the Query that the report is based on.
Could anyone please advise what the problem could be?

Thanks for any help

 

[John W. Vinson]

I have designed a data Base in access 2003, and it basically works in Access
2007 with a a bit of tweaking.
The trouble is that some reports now ask for "A parameter value" eg:
'Lastname'. This field is not in the Query that the report is based on.
Could anyone please advise what the problem could be?

Thanks for any help

Check the report's Sorting and Grouping property - perhaps it's trying to sort
by lastname.

It could also be a control property, such as the Master Link Field of a
subform, or it could be referenced in a combo or listbox's rowsource query.

John W. Vinson [MVP]