TempVars.add and make value ID

[Ruegen]

I'm using TempVars.Add so I can make a new stored Temporary Variable

The goal is to store the forms record ID (table ID)

I'm stuck on the expression.

TempVars.Add (name,value)

I thought it would be

TempVars.Add (tmpCopyID, me.SchoolID)

I get a compile error Expected:=



I've found a solution which doesn't use tempvars however I would still like to know the answer to this...

[June7]

The variable name must be provided as a string, so try:

TempVars.Add ("tmpCopyID", Me.SchoolID)

[Ruegen]

*smacks own head*

thanks

[June7]

Been there, done that

[MarvinM]

The variable name must be provided as a string, so try:

TempVars.Add ("tmpCopyID", Me.SchoolID)

I got an error when I used the parentheses. No error without. Try this:

TempVars.Add "tmpCopyID", Me.SchoolID