Changed Field Names and getting a Parameter Query

[Guest]

I have changed my field names in both my table and form but when entering the
form it is coming up with a parameter query. The old field name is in the
dialog box, but I can't find where I have missed renaming the field anywhere
in my database. Where is this query coming from? Does anyone have any
suggestions? Thanks.

 

[Guest]

Could be that the record source of your form is a query - not the actual
table - and the field name needs to be updated in the query.

HTH

 

[Guest]

Open the Form in Design View and Press F4 function key to open the Properties
window. Check the record source to see if a query is showing. If so, click
to the far right of the row and edit the attached query.

 

[Larry Daugherty]

Lots of places where something like that could sneak in: in the
parameter of a parameter query, in the criteria line prompt, hanging
around in the underlying query, etc.

You might try a global search on the wrong field name. Great tools
for super searches are:

Find And Replace from Rick Fisher at Rickworld.com Shareware

Speed Ferret from Moshannon Software commercial

Both products are highly recommended.

HTH