PARAMETERIZED PASS-THROUGH QUERY using textbox on form.

  • Thread starter Thread starter CT
  • Start date Start date
C

CT

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
 
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 & "'"
 
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.
Currentdb.QueryDef("qsptMyPassthrough").SQL = "Select...Where fName ='" &
Forms!frmName.txtFName & "'"

--
Duane Hookom
MS Access MVP


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
Click to expand...


.
Click to expand...
 
Back
Top