Consultant

Mik Mak

Gustav Brock

<div>
You can also use TempVars:<br />
<br />
Tempvars.Add(&quot;AccountNumbe<wbr />r&quot;, YourAccountNumber)<br />
<br />
Then grab that value:<br />
<br />
Tempvars.Item(&quot;AccountNumb<wbr />er&quot;)
</div>


You can also use TempVars:

Tempvars.Add("AccountNumber", YourAccountNumber)

Then grab that value:

Tempvars.Item("AccountNumber")

Microsoft Developer

Anders Ebro (Microsoft MVP)

<div>
<div class="content wysiwyg-content">
I want to use/refer to a Public Const (pubAccNo) in a textbox on a report (see example below) - but when running the report it asks for the value of the constant - can global constants not be referred to on a report ?<br />
<br />
ControlSource = &quot;Accountnumber: &quot;&nbsp;&amp; pubAccNo
</div>
</div>


I want to use/refer to a Public Const (pubAccNo) in a textbox on a report (see example below) - but when running the report it asks for the value of the constant - can global constants not be referred to on a report ?

ControlSource = "Accountnumber: " & pubAccNo

Using global constant on report

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.