Parameter Query keeps repeating itself...

  • Thread starter Thread starter Gary Smith
  • Start date Start date
G

Gary Smith

Hello--

How do I stop a Parameter query from repeating the
parameter question(s) a second time? I was told to add a
PARAMETER line to the beginning of the SQL code, which I
did. It worked -- for awhile. Then it started happening
again. I've also tried rebuilding the query from scratch.
That too worked -- for awhile.

Why can't I solve this problem permanently? I suppose a
more constructive question would be, How can I solve this
problem permanently? It's becoming a pet peeve...

Thanks once again for any assistance that may be
forthcoming.

--Gary
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You're, probably, re-sorting or filtering the query after you run it (in
datasheet view) & then closing the query w/o removing filtering/sorting
options (right click on the query & select the remove filtering...
option).

If you really want to avoid repeated prompting, use a reference paramter
instead of a requesting parameter. E.g.:

PARAMETERS Forms!form_name!control_name Long;
SELECT *
FROM table_name
WHERE Column1 = Forms!form_name!control_name

The form "form_name" will have to be open and a valid value in the
control "control_name."

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQRPPQoechKqOuFEgEQICuQCg/9Ga0lzjR8P5ICubLnp0nefY7UIAoKmu
lUthTt3hwyFsofO28f6QnPsG
=29LP
-----END PGP SIGNATURE-----
 
MGFoster--

Thanks -- the right-click "remove filtering" suggestion
worked like a charm! (Good thing, too: I didn't want to
have to resort to building a whole new form just for this
purpose... ! )

--Gary
 
Back
Top