How to use Tempvars in query

[JrMontgom]

Hi I have a small problem and I can't solve it so Iwould really appreciate any help. I am creating a query on the "fly" in VBA. The date is the variable stored in Tempvars. I create the Tempars as follows:


Tempvars.Add "tvStartDate",strStartDate. How do I express that in the Query Designer? I haveentered Tempvars("tvStartDate") but it says incorrect string. I have tried =Tempvars("tvStartDate") and get the same result? I get the strStartDate by either user input or from text box on form and it is valid in debug.print

[June7]

I am familiar with but never used TempVars.

Post the VBA code that constructs the SQL statement.

[JrMontgom]

I am familiar with but never used TempVars.

Post the VBA code that constructs the SQL statement.

Thanks June but I found out that you need to put brackets around the Tempvars ex [Tempvars("tvData")] to get it to work
Consider this solved (Now how tdo I mark it solved? hmmmm)

[June7]

Thanks for sharing the solution.
Thread Tools dropdown above first post.