Enter Parameter Value

  • Thread starter Thread starter Fox
  • Start date Start date
F

Fox

Hi I'm getting the "Enter Parameter Value" error...and can't find the where
it is referencing...
I have a db that I split the tables...I useally work on the front end only
but then decided that a field in a backend table needed to be deleted as it
was not needed and causing issues.
So I removed it and updated all querys etc to make sure that this field was
not referenced any where.
So I have a report that is opened from a menu button that is a macro to open
report. The report uses a form with a selection box to select criteria...it
use to use the field that I deleted but I changed the query so that it uses
the a different field now...
Anyway I looked at the macros, I looked at the form which is only using a
macro I looked at the query behind the report and all the fields...
I can not find a reference to this old field anywhere and I really believe
there is not a reference anymore to this field. I've remade the querys, I re
made the report and I still get this error.
I rebooted PC thinking it was a refresh issue..
Is there anyplace else I should look?
 
Foxy,

Is the field used in the Sorting & Grouping in the report design?

Is the field used in an expression in the Control Source of a calculated
control on the repor?

Is the report's record source query based on another query? If so, check
that query too.

Does the form contain a combobox? If so, check the Row Source of the
combobox,
 
Back
Top