message

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

Guest

When I use a text box on a form to enter criteria (709 or 3116) for a query I
get the message "you canceled the previous operation". If I just type in 709
the query works.
 
Parameter queries don't do any parsing. They don't take your "709 or 3116"
and convert it into "NameOfField = 709 Or NameOfField = 3116". They're not
that smart. They'll use it just the way you give it to them - "NameOfField =
709 or 3116". To do what you're trying to do here, you'll need two text
boxes, and you'll need to edit the query to something like ...

"NameOfField = Forms!NameOfForm!NameOfFirstTextBox Or NameOfField =
Forms!NameOfForm!NameOfSecondTextBox"

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
When I use a text box on a form to enter criteria (709 or 3116) for a query I
get the message "you canceled the previous operation". If I just type in 709
the query works.
Click to expand...

is 709 a string or a number?
the field or control matches this?

if string then you have to put it in quotes
 
I'm using a form with a command button that executes an event procedure when
the cmd button is clicked.

The text box is where I'm typing in the "709 or 3116" information. Then the
module function is executed from query after clicking the cmd button,
 
Back
Top