<div>
Try this:<br />
<br />
Create a separate form that includes only the single textbox you'd mentioned above, using the query as the recordsource for that form.<br />
<br />
Then, on the switchboard form, insert the form you just made above as a subform.<br />
<br />
The value should display properly if you use a subform in this manner.
</div>


Try this:

Create a separate form that includes only the single textbox you'd mentioned above, using the query as the recordsource for that form.

Then, on the switchboard form, insert the form you just made above as a subform.

The value should display properly if you use a subform in this manner.

<div>
Thanks puppydogbuddy-<br />
Precisely what I was after! &nbsp;<br />
Apparently the quotes and brackets are important...guess I never managed to get to that paricular combination!<br />
<br />
sah18-<br />
Thanks. It's one of those times when the other solution exactly matches the need. Thanks for the very useful &nbsp;information 
</div>


Thanks puppydogbuddy-
Precisely what I was after!  
Apparently the quotes and brackets are important...guess I never managed to get to that paricular combination!

sah18-
Thanks. It's one of those times when the other solution exactly matches the need. Thanks for the very useful  information

<div>
tmccar10,<br />
You are welcome. &nbsp;Glad I could help you resolve your problem.<br />
PDB
</div>


tmccar10,
You are welcome.  Glad I could help you resolve your problem.
PDB

<div>
Just glad to hear you got it working!!
</div>


<div>
<div class="content wysiwyg-content">
I have made a switch for an update process.<br />
I'd like to show the current maximum date of the records in the main table as a reference.<br />
I've made a query and a one-record table to create the value and tried to put it in a textbox on the form.<br />
That's not gettin' it.<br />
Can I even do what I'm trying?<br />
<br />
Thanks
</div>
</div>


I have made a switch for an update process.
I'd like to show the current maximum date of the records in the main table as a reference.
I've made a query and a one-record table to create the value and tried to put it in a textbox on the form.
That's not gettin' it.
Can I even do what I'm trying?

Thanks

Display a variable value on a switchboard

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.