Enter Parameter Value

[injanib via AccessMonster.com]

My report used to have a filed called "Customer ID". This field also existed
on my table and form.
I decided to remove this field because it didn't really serve any purpose. So
I deleted the field from the report, form and table. But now when I open the
report it asks to enter parameter value for Customer ID. If I don't enter
anything and click ok, it still opens the report. But I can't figure out why
it asks me this when the field has been removed from everywhere.

 

[Mike Painter]

My report used to have a filed called "Customer ID". This field also
existed on my table and form.
I decided to remove this field because it didn't really serve any
purpose. So I deleted the field from the report, form and table. But
now when I open the report it asks to enter parameter value for
Customer ID. If I don't enter anything and click ok, it still opens
the report. But I can't figure out why it asks me this when the field
has been removed from everywhere.

If the report was sorted on that value it probably is still in the sort
order form.

 

[Douglas J. Steele]

Remember that reports get their data order from the report's Sorting and
Grouping dialog, not from the sort order of the query (or table) that makes
up the recordsource. Had you perhaps included Customer ID there?

 

[injanib via AccessMonster.com]

I have checked the Sorting and Grouping as well. I never used Customer ID for
sorting or grouping, but I checked it anyways.

Any other ideas?

Remember that reports get their data order from the report's Sorting and
Grouping dialog, not from the sort order of the query (or table) that makes
up the recordsource. Had you perhaps included Customer ID there?

My report used to have a filed called "Customer ID". This field also
existed

[quoted text clipped - 7 lines]

why
it asks me this when the field has been removed from everywhere.

 

[Douglas J. Steele]

Is the report based on the table, or on a query? If it's a query, did you
remove Customer ID from the query?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have checked the Sorting and Grouping as well. I never used Customer ID
for
sorting or grouping, but I checked it anyways.

Any other ideas?

Remember that reports get their data order from the report's Sorting and
Grouping dialog, not from the sort order of the query (or table) that
makes
up the recordsource. Had you perhaps included Customer ID there?

My report used to have a filed called "Customer ID". This field also
existed

[quoted text clipped - 7 lines]

why
it asks me this when the field has been removed from everywhere.

 

[injanib via AccessMonster.com]

it is based on a query and yes I did remove it form the query. There is no
Customer ID field or any unknown expression in the query.

Is the report based on the table, or on a query? If it's a query, did you
remove Customer ID from the query?

I have checked the Sorting and Grouping as well. I never used Customer ID
for

[quoted text clipped - 12 lines]