how to clear a parameter dialog box that isn't connected to any parameter.

[Amyfb]

I have a report (rptDatasets) that throws up a dialog box referring to a field that has been deleted from both the underlying table as well as the report design.

I have opened every single query and checked the parameters box - none of the queries has a parameter set.

I don't know where this is coming from and I don't know how to make it go away.

Any ideas welcome.

zipped db file attached.

[Micron]

Your report recordsource property contains a sql statement that has that field in the sql yet there is no such field in the table.

EDIT - BTW, that's not a guess, it's a fact.

[ranman256]

its usu always misspelled field, or missing field.

[davegri]

You didn't mention the name of the field being sought but it's probably this one which is in the recordsource of the report, but does not exist in the table:

SELECT tblVersionStatus.VersionStatus_Name, [tblDocuments].DATASET_NAME, tblVersions.VersionNumber, tblVersions.Revision, tblVersions.Version_Change_Date, tblLocations.Location_Name, tblLocations.Location_Details, tblDocuments.DOCUMENT_NUMBER FROM tblVersionStatus INNER JOIN (tblDocuments INNER JOIN (tblLocations INNER JOIN tblVersions ON tblLocations.[Location_ID] = tblVersions.[fkFile_Location]) ON [tblDocuments].DATASET_ID=tblVersions.fkDataset_ID) ON tblVersionStatus.VersionStatus_ID = tblVersions.fkVersionStatus ORDER BY [tblDocuments].DATASET_NAME;

[Amyfb]

Your report recordsource property contains a sql statement that has that field in the sql yet there is no such field in the table.

EDIT - BTW, that's not a guess, it's a fact.

Many thanks. That was an easy edit, but I doubt I'd have ever found it on my own. I would have just recreated the report and never known what made a new one work correctly.

THis was good experience and will help me troubleshoot more effectively in the future.

thanks again.

[Amyfb]

thanks! I saw Micron's reply before yours; good eyes on both of you!

You didn't mention the name of the field being sought but it's probably this one which is in the recordsource of the report, but does not exist in the table:

SELECT tblVersionStatus.VersionStatus_Name, [tblDocuments].DATASET_NAME, tblVersions.VersionNumber, tblVersions.Revision, tblVersions.Version_Change_Date, tblLocations.Location_Name, tblLocations.Location_Details, tblDocuments.DOCUMENT_NUMBER FROM tblVersionStatus INNER JOIN (tblDocuments INNER JOIN (tblLocations INNER JOIN tblVersions ON tblLocations.[Location_ID] = tblVersions.[fkFile_Location]) ON [tblDocuments].DATASET_ID=tblVersions.fkDataset_ID) ON tblVersionStatus.VersionStatus_ID = tblVersions.fkVersionStatus ORDER BY [tblDocuments].DATASET_NAME;

[Micron]

FWIW, another place the issue can hide besides a record source is in calculated controls.

EDIT- I just realized my first post (answer) was as if you had posted the prompt when in fact I saw it in the db.