message box: 'enter a parameter value' without my having set one

[datamanipulator]

I have set up a query with no criteria set as of now- but when I open the
query I get the message: 'enter a parameter value' referencing three of the
twelve filed in the query. How do I resolve this please?

 

[Philip Herlihy]

I have set up a query with no criteria set as of now- but when I open the
query I get the message: 'enter a parameter value' referencing three of the
twelve filed in the query. How do I resolve this please?

"Enter a parameter value" means Access isn't recognising the name in the
query. Check for typos. This mechanism is intended to allow you to
supply a value on the fly - Access asks you for the missing value if the
name isn't found in the source tables.

Phil, London

 

[ruralguy via AccessMonster.com]

THat usually means you have not spelled the field names correctly.