Software

Ask something
Discussion Locked

MS access-report printing

0 helpful
8 replies

by cakester

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have created a report based on several tables but when I want to print this multiple page report I get a message box titled "enter paramater name" and asks for a subunit name. I can still print the report by clicking on OK but I want to get rid of this messagebox. Can anyone suggest a solution?

8 replies

by dklippert

Check your spelling.
A parameter request means Access cannot find a data source. The most common cause is not having the exact name

by ichu50

Switch to the design view of the report and make sure that all the field names are exactly as named in the tables including spaces.

by cakester

I have tried both of these solutions but I still get this message. Would it be coming from the querry table the report is pulling from?

by sgt_shultz

yes. it would be coming from the query. make the error happen and write it down being careful with exact spelling of the name of the parameter it wants. go and look in your query for this spelling in one of the formula or probably just in a 'column' name. for some reason access doesn't know what to do with it. means you have a syntax error there somewhere. commonly a typo as mentioned already. your results are questionable until you understand this error, yes? for more information see 'parameter query' in Access Help

This discussion is closed to new replies.