Stored Procedure

[Joao Pedro]

Hello, how can i filter the Value of a Text Box in a SP, the bellow is not
working, thanks

SELECT CP3, CPALF
FROM dbo.T_CODIGOS_POSTAIS
WHERE (CPALF = N'Forms!frmCLIENTES_GERAL!tboxCodPostal.Value')

 

[BJ Freeman]

sqlstr = "SELECT CP3, CPALF FROM dbo.T_CODIGOS_POSTAIS WHERE
(CPALF ='" & Forms!frmCLIENTES_GERAL!tboxCodPostal.Value & "'"

note: this is all one line the ' is for SQL the " is for VBA