syntax issue - variable in stored proc execution 1

[belovedcej]

The line below has incorrect syntax at the intPersonID. It is a Long type in VBA, an integer type on the server.

Could someone advice me as to what my syntax problem is? Thanks!

Set rst = CurrentProject.Connection.Execute("dbo.CSF_Addresses_List_SP(intPersonID)")

 

[SkipVought]

Hi,

Set rst = CurrentProject.Connection.Execute("dbo.CSF_Addresses_List_SP(" & intPersonID & ")")

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[belovedcej]

Thanks! I'm still fuzzy on details like that and miss what may seem obvious. I appreciate the quick responce!

 

[SkipVought]

It just simple concatenation of strings to form the SQL string.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}