<div>
The syxtax is <br />
<br />
TempVars.Add &quot;myVisitFreq&quot;, me.txtVisitFrequency
</div>


The syxtax is

TempVars.Add "myVisitFreq", me.txtVisitFrequency

<div>
Yes. &nbsp;It seems it needed the .Value at the end.
</div>


Yes.  It seems it needed the .Value at the end.

<div>
<div class="content wysiwyg-content">
I'm sure I'm doing this all wrong but I'm trying to set the value of a TempVar when a form opens with...<br />
<br />
&nbsp; &nbsp; Dim myVisitFreq As Integer<br />
&nbsp; &nbsp; TempVars.Add myVisitFreq = me.txtVisitFrequency<br />
<br />
But it doesn't work. &nbsp;What is wrong with it?
</div>
</div>


I'm sure I'm doing this all wrong but I'm trying to set the value of a TempVar when a form opens with...

    Dim myVisitFreq As Integer
    TempVars.Add myVisitFreq = me.txtVisitFrequency

But it doesn't work.  What is wrong with it?

TempVars with onload event of a form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.