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

  • Thread starter datamanipulator
  • Start date
D

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?
 
P

Philip Herlihy

datamanipulator said:
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
 

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

Top