Passthru Query with Form Variable?

[jayde]

Is there a way to pass variables from a form to a passthru query? I know this can be done using querydef, but it would be faster to do with a passthru query if I can pass variable information.

Thanks in advance..

\ \ \ | | / / /
[--O-O--]
{{ (_) }}
{{{-}}}

Jayde

 

[tlbroadbent]

It is possible to do. Check the following links for methods.

http://support.microsoft.com/support/kb/articles/Q131/5/34.asp

http://msdn.microsoft.com/library/en-us/dnacc2k/html/adocreateq.asp

http://support.microsoft.com/support/kb/articles/Q142/9/38.asp

Access 97 samples:

http://download.microsoft.com/download/access97/samp/1/WIN98/EN-US/QRYSMP97.exe

Access 2000 samples:

http://download.microsoft.com/download/access2000/Sample/1.0/W9X2KMe/EN-US/Qrysmp00.exe

Check faq701-721 for more developer resources. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Kubilus1]

I responded to a question like this in a previous post:

thread701-91679 The above was an example for executing a parameterized stored procedure in sql, but your purposes should be similar.

Matt