Mystery Parameter

[DianeM]

I have a database of issues based on a template. I have changed some
field names throughout the database, for instance "Status" has become
"IssueStatus."

I am working on a report of open issues, but I keep getting prompted
for the "Status" paramenter when I open the report.

I have checked the following:
- The query that the report is based on opens fine with no parameters
needed.
- I have deleted the group sort on "Status."
- There does not appear to be any event-related code in this form.

Does anyone have any ideas of where I have forgotten to look?

Thanks in advance!

 

[Roger Carlson]

Is there a control that has Status as its ControlSource?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[KARL DEWEY]

Click on menu TOOLS - Analyze - Documenter. Select your table, select all
options, click ok, click ok. Click on icon that is a blue 'W' and it will
create a Rich Text Format file. Search on 'Status' and see where the culprit
is.

 

[DianeM]

Click on menu TOOLS - Analyze - Documenter. Select your table, select all
options, click ok, click ok. Click on icon that is a blue 'W' and it will
create a Rich Text Format file. Search on 'Status' and see where the culprit
is.

Thanks for this ... I've found the culprit, but I don't know how to go
in and fix it. In the description for the query, the RowSource
property for the StatusID field is given as "SELECT Status.Status FROM
Status ORDER BY [Status];" ... but I cannot find this related to the
field in either the query or the underlying record.

Any ideas on how I can delete the RowSource info from this field?

 

[KARL DEWEY]

Save a copy of the query by adding a -1.

Open the orignal query in design view, click on menu VIEW - SQL View. Edit
the SQL statement like this ---
SELECT Status.IssueStatus .......
FROM Status
ORDER BY [IssueStatus];

--
KARL DEWEY
Build a little - Test a little

Click on menu TOOLS - Analyze - Documenter. Select your table, select all
options, click ok, click ok. Click on icon that is a blue 'W' and it will
create a Rich Text Format file. Search on 'Status' and see where the culprit
is.

Thanks for this ... I've found the culprit, but I don't know how to go
in and fix it. In the description for the query, the RowSource
property for the StatusID field is given as "SELECT Status.Status FROM
Status ORDER BY [Status];" ... but I cannot find this related to the
field in either the query or the underlying record.

Any ideas on how I can delete the RowSource info from this field?