PARAMETERIZED PASS-THROUGH QUERY using textbox on form.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CT - 08 Oct 2004 00:33 GMT

SUBJECT: PARAMETERIZED PASS-THROUGH QUERY using textbox
on form.

Can this be done? If so what is the SQL code for Access
2000 (and 2003)? I have tried SQL logic from other
applications but have struck out.

Some trys:
like [Forms]![frmNAME].[TextboxNAME]
= [Forms]![frmNAME].[TextboxNAME]
like :[Forms]![frmNAME].[TextboxNAME]
=?

CT

Reply to this Message

Duane Hookom - 08 Oct 2004 02:48 GMT

You can use DAO code to change the SQL of a saved query such as a p-t.
Currentdb.QueryDef("qsptMyPassthrough").SQL = "Select...Where fName ='" &
Forms!frmName.txtFName & "'"

Signature

Duane Hookom
MS Access MVP

> SUBJECT: PARAMETERIZED PASS-THROUGH QUERY using textbox
> on form.
[quoted text clipped - 10 lines]
>
> CT

Reply to this Message

CT - 08 Oct 2004 18:04 GMT

Thank you for the help.

>-----Original Message-----
>You can use DAO code to change the SQL of a saved query such as a p-t.
[quoted text clipped - 17 lines]
>
>.

Reply to this Message