Access Parameter Popup - Needs to be Removed

[Hmadyson]

Hi, I have an access report which I created from an access form. I did a Save as on the form to create a report. Without making any changes to the report, when I open it, I get a parameter popup asking for a field called txtPhoneHome (although the name probably doesn't matter, but it may be a field on a different form, but has nothing to do with this form). I do not get that same popup on the original form.

I have looked at the Recordsource of the report, which is a table that has no hidden sorts or filters or anything. I have looked at every control and none of them have anything to do with this parameter. If I remove the RecordSource for the Report, it opens without the parameter, but #name? on all of the controls. I do have a bunch of dropdowns, but I have checked the rowsource on them to make sure that it is something that should work.

The report has no sorts or filters on it. I also set the HasModule to No and the popup comes up, so I think that VBA is not providing this popup.

I am hoping that some Access Report genius can give me a quick idea of something that I am not thinking about.

Thanks so much.

 

[dhookom]

Did you check the sorting and grouping in the report design?

Duane
Hook'D on Access
MS Access MVP

 

[Hmadyson]

Yes I did. Other ideas?

 

[dhookom]

You can try the documenter in Access and then search the results using information from Flexible Reporting of Documenter Results. You could also print to PDF and then search the PDF file.

Duane
Hook'D on Access
MS Access MVP

 

[Hmadyson]

For future knowledge, this popup was occurring because there was conditional formatting in the form which was converted into a report. Next time I will know to look there. Thanks.

 

[dhookom]

Thanks for reporting back. I guess I wouldn't have thought to look through conditional formatting expressions. But I don't use conditional formatting that often and rarely convert a form to a report.

Duane
Hook'D on Access
MS Access MVP