parameter passthrough query

  • Thread starter Thread starter Manju
  • Start date Start date
M

Manju

In a pass-through query we are calling a stored procedure. How do we pass
forms data as a parameter to the Stored Procedure.
I tried this
Execute spr_3abcdAddUpdtQueries([Forms]![ProcessDates]![StartDate] ,
[Forms]![ProcessDates]![EndDate])

it is not able to recognize the parameters.
 
I use some DAO code to modify the sql property of the saved pt query

Dim strSQL as String

strSQL = "Execute spr_3abcdAddUpdtQueries '" &
[Forms]![ProcessDates]![StartDate] & "' ,'" &
[Forms]![ProcessDates]![EndDate] & "'"

CurrentDb.QueryDefs("qsptNameOfPT").SQL = strSQL
 
Back
Top