"inter parameter value"

"inter parameter value"
i get prompt "inter parameter value" when i open query . how do i can to
prevent it? thanks

siahman wrote:
"inter parameter value"
i get prompt "inter parameter value" when i open query . how do i can
to prevent it? thanks

Your query is referring to an object that does not exist within its
scope when the query runs. A misspelled field name, prehaps? Or a
reference to a form control whose form is not open? To prevent it, you
have to fix whatever is wrong. You can figure out for yourself what the
problem is by removing elements from the query until the symptom stops
appearing when you test the query.

For more specific help, you need to show us the query that is causing
the problem. Switch to SQL View and copy/paste the sql statement into
your reply to this message. It would really help if you followed the
advice given above to try to identify the text in the query that is
causing the error.

--
HTH,
Bob Barrows

That's Enter Parameter Value. Access is looking for some value to run the
query properly. It could be a number of things. There's only one practical
way for us to know: Show us the SQL. Open the query in design view. Next go
to View, SQL View and copy and past it here.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"siahman" wrote:

"inter parameter value"
i get prompt "inter parameter value" when i open query . how do i can to
prevent it? thanks

On Tue, 19 Jan 2010 08:21:01 -0800, siahman
wrote:

"inter parameter value"
i get prompt "inter parameter value" when i open query . how do i can to
prevent it? thanks

dig a hole and bury (inter) it...???

The prompt (if you have an English languange installation) is surely "Enter
parameter value", and it's asking you to provide the value of some parameter
(it tells you what parameter, but you didn't tell us) that it can't recognize.
If you have anything in your query in [square brackets] which Access can't
recognize you'll get the prompt. Sometimes this can be a valid way to ask the
user to provide a criterion for a query; or it can be a misspelled fieldname,
or something else that Access can't recognize.

Please open the query in design view, select View... SQL from the menu, and
post the SQL text of the query to a message here. Indicate what parameter
Access is prompting you for, and if need be the fieldnames in your table.
--

John W. Vinson [MVP]