Executing Stored Procedure w/ Param in ADP 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been working with Access a long time but just recently started with
APD - Sql Server 2000. I have a popup form where I pass a contactid to the
form and set the recordset (a stored procedure with a parameter) after the
form open event.

The form has no set Record Source and no set Input Parameters. After
getting the ContactId that I wish to lookup I perform the following in my
code.

Me.RecordSource = "Exec spac_WindowVendorContact " & ContactId
Me.requery

I don't receive an error but I always get an empty recordset returned. I
have verified that the stored procedure works and that it is looking for a
contactid parameter. This should be really easy but it has me stumped. I
have searched extensively here and in google and I still don’t haven’t found
the answer.

Any ideas?
 
Back
Top