Hello, some where in here there is something wrong with my code. I'm trying to run some vb to push to a Access 2007 pass-through query connected to a SQL Server.
Per_Diem_Calculator is the name of the query and usp query on the sql side. Forms![NewOrdersCa]![TS] is essentially the current ID number on the form I'm viewing to compare to a variable I created on the SQL side.


CODE:
Dim DB As Database
Dim A As QueryDef

Set DB = CurrentDb()
Set A = DB.QueryDefs(Per_Diem_Calculator_CA)
A.SQL = "exec dbo.usp_Per_Diem_Calculator_CA & " '" & Forms![NewOrdersCa]![TS] & "'"

DoCmd.OpenQuery "Per_Diem_Calculator_CA"


Thank you!
David92595

What is happening that shouldn't be, or what is not happening that should be?

What does the stored proc look like?

"Forms![NewOrdersCa]![TS] is essentially the current ID number on the form I'm viewing to compare to a variable I created on the SQL side. "

hm. Either it IS the current ID or it IS NOT the current ID.

It should be passing "exec dbo.usp_Per_Diem_Calculator_CA 'ID' "to a pass through query. but every time I run it nothing happends, the query isn't run; and when I look at the details of the query there is only a ":" in the pass through query.

Forms![NewOrdersCa]![TS] IS the current ID.

This line should be

Set A = DB.QueryDefs("Per_Diem_Calculator_CA")

THANK YOU!!!! (IMG:style_emoticons/default/woohoo.gif)

I knew it was some small little typo like that.

I need to remember those quotation marks...

I can't thank you enough, I'm the only programer at my company so I don't have a second set of eye to check my work. (IMG:style_emoticons/default/crazy.gif)

Thanks again,
David92595

Congratulations on resolving your problem. Continued success with your project.