Changed Field Names and getting a Parameter Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Invalid bracketing of parameter name 1
Query Parameter using multiple options 0
Using a Parameter Query in a Report? 2
Parameter Value error in a Subform 0
Enter Parameter Value in Access Form 0
report after parameter form 3
Use Parameter Form to export a query 3
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Back
Top