Unwanted parameter dialogue box!

G

Guest

In my Corporates table (and on the associated form) I have a field called
Mailshot? and it is formatted as a Y/N. Needless to say, this is to flag
which companies are to be included when we draft our mailshots.
I have a Query that reports every field on my Corporates form, all the basic
data about each company and including this Mailshot field.
However, as soon as I try to run the Query, it presents a dialogue box
saying Corporates:Mailshot
Surely it shouldn't be asking the question as part of the Query???
What have I done wrong?
Many thanks
CW
 
G

Guest

Check for spelling.

Can you enter text such as 'How now' and will the query run or give an error
message after this input.

What result do you get when you ignore the prompt and press ENTER?
 
G

Guest

Well, after submitting my post I removed that field from the Query and it
cured the problem.
But to test it as you had suggested, I have now re-entered the field in the
Query and whaddya know, it runs fine!!!!!!
Destined to remain one of life's (Access's) little mysteries, it would seem.
If it does re-appear I will check the behaviour as you suggest and will
re-post.
Thanks for your help anyway
CW
 

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