SQL Server - Passing Parameters

[stubailey007]

Hi,

After years and years of working with Jet, I am now trying to use SQL Server backands and am having problems passing parameters to a stored procedure.

How can I build a query which where I can say "WHERE ([AField]=""" & Forms!BlarBlaretc.value & """)" as I can in access because as I understand it you can not look at front end information from the SQL backend.

Any help (and start at the beginning) would be much appreciated.

Cheers

Stu

 

[BryanT]

Hello stubailey007

Set the command text of an ADODB.Command object to -

"exec YourProcedureName'" & Parameter1 & "','" & Parameter2 & "'"

then execute the command

I hope this helps