Deleted field still requiring input

[bao371]

I have a access 2007 database that I converted from Access 2003 version.
After converting the database I was editing one of the reports pages and
deleted the old attachment field from the report. I modified the attachment
field in the table upgrading the field to the new 2007 attachment, but
removed that field from the report.
I now get a prompt every time I open the report to enter a value for the
attachment. It does not mater what value I enter but I must enter a value, if
I click cancel the print will stop.

Anyone have any ideas how I can remove this old attachment from my report?

 

[Dirk Goldgar]

I have a access 2007 database that I converted from Access 2003 version.
After converting the database I was editing one of the reports pages and
deleted the old attachment field from the report. I modified the
attachment
field in the table upgrading the field to the new 2007 attachment, but
removed that field from the report.
I now get a prompt every time I open the report to enter a value for the
attachment. It does not mater what value I enter but I must enter a value,
if
I click cancel the print will stop.

Anyone have any ideas how I can remove this old attachment from my report?

Check the report's RecordSource property to make sure it isn't still
explicitly selecting a field by this name. Also check the report's Filter
and OrderBy properties to make sure the field isn't named there.

 

[Mushroom]

Sounds like the report is based on a query. Check properties on the report.
Click the 'data' tab and see what the record source is. If it is a query,
you can hit the ... and open the query in design view, then delete that
field.