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