Stored Procedure

  • Thread starter Thread starter Joao Pedro
  • Start date Start date
J

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')
 
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
 
Back
Top