Enter Parameter Value

[jcbhydro]

Good Evening,

I have noted several instances of the dreaded 'Enter Parameter' message occurring on Queries and Reports of my Database. I have been able to resolve all but one of these by examination of the relevant Property Sheet.Record sources to correct anomalies.
One of the instances has defeated me. I have a simple Report names Mail List Basic' which takes selected data directly from the Table Mail List for the purpose of producing a pdf file.. On initiating the Report the 'Enter Parameter Value' appears with the title 'Mail List'. Selecting OK runs the Report without problem.
The Property Sheet for the Design view shows Mail List as the Record Source. The Order is [Mail List].Surname which seems to be correct.

Any suggestions would be much appreciated.

jcbhydro

 

[GinaWhipp]

Check under Grouping & Sorting while in Design View of the Report.

 

[jcbhydro]

Thank you Gina,

Selecting 'Group & Sort' in Design View shows only the <Add> facility and nothing else. As previously mentioned, the Property Sheet does show Order as [Mail List]. [Surname] but that is required.
Strangely, I have a virtually identical Report which takes similar data from the same Table [Mail List] but which doesn't produce the 'Enter Parameter Value' message It has an identical Order feature. I can't find any difference in the relevant Property Sheets. Very puzzling!

regards,

jcbhydro

 

[GinaWhipp]

Hmm, thought it might be there. I would remove the Order By and see if that removes the error.

 

[jcbhydro]

I tried that yesterday, and again today, but my records are then sorted on the primary key instead of in surname order and the Parameter error is still there.

Could it be anything to do with the fact that the Report doesn't actually use the Surname field in its printout. It is of course included in the [Mail List]Table from which the Report is derived. The Report itself uses a concatenation of the First and Surname to produce a field called [Member Name].

Regards,

jcbhydro

 

[Galaxiom]

Have you checked the RowSource of any Combos or ListBoxes?

 

[jcbhydro]

Gina,

Thanks for your further suggestion, but I don't have any Combo's and can't find anything significant in list Boxes.

I did follow up my own thought about the concatenated 'Member Name' and replaced it with a simple First Name & Surname, but it made no difference, I still get the Enter Parameter message.

At this point, I am calling it a day. I am resigned to needing to click<OK> when the message appears.

I am exceedingly grateful for your thoughts on the subject.

Regards,

jcbhydro

 

[Minty]

Is there a underlying stored query for the report?

If so check you haven't inadvertently added an underlying parameter to the query. (Right Click in the query design view and select the Parameter option, the box that comes up should be empty)

 

[GinaWhipp]

I would not be resigned to clicking OK as you can't 100% sure all results are being returned. I would suggest you get out a pen and paper and start your check, writing down each thing you checked, again. Then you can be sure you did check everything, including and code or macros. A bit tedious but you really should find it.

 

[Galaxiom]

Use Total Deep Search in V-Tools to find the expression being thrown up as a parameter.

 

[jcbhydro]

Gina,
Your perseverance is admirable.

The Report in question is simplicity itself and is derived directly from the [Mail List] Table. It is there merely to produce a pdf file for Committee Members without Access 2010. The Report title is 'Mail List Basic'. When you talk about an 'underlying query' I have assumed that you are referring to a query specifically related to the Report in question. This Report has no such query.
The database does have some 15 other queries, built to perform other functions, but not used for the Report.

Strangely, another Report, entitled 'Member Preferences' is produced from the same [Mail List] Table using a number of different fields, but doesn't produce the 'Enter Parameter' message.

Regards,

jcbhydro

 

[GinaWhipp]

Then it must be somewhere in that Report, that's the good news! If the Report has no query what is the Report's Recordsource?

(Thanks for the kind words!)

 

[Minty]

If there is no underlying query - just the table, then you must have a control somewhere on the report that is called 'Mail List'

If you open the report in design view and open the report properties see if there is a control listed called Mail List in the drop down box in the properties section?

 

[GinaWhipp]

Do any of the Fields in the Table utilize Look-Up's?

 

[jcbhydro]

I have followd your advice but the only reference to 'Mail List' in the Report property sheet is the Record Source. I have examined the property sheet for all elements of the Table Design View with the same negative result. The only other reference was in the Order Statement [Mail List].Surname. Removing [Mail List] from this statement has no effect.

There are no 'Lookups' used by the Table.

Regards,

jcbhydro

 

[GinaWhipp]

It is not the Property Sheet for the Table you need to examine. You need to examine the tabs below for each Field in your Table. You need to confirm you are not using a Look-Up field which is looking for the Surname.

 

[jcbhydro]

Hi,

I obviously didn't make myself clear.

When I said that I had examined all elements of the Report, I meant that I had examined the property sheets for each & every field of the Report and I did the same for each field of the relevant Table. I found no evidence of 'Lookups' in any of the many property sheets.

I am now thinking seriously of rebuilding a new Report from scratch as a means of getting rid of the offending message = hopefully.

Regards,

jcbhydro

 

[fat controller]

I had this a couple of times, and all I did was create a blank report, and copy and paste everything from the 'old' report into the blank one, then set the record source to the desired query - seemed to solve it for me.