<div>
That worked great. Thank you.
</div>


<div>
<div class="content wysiwyg-content">
I have a MS Access 2007 database that is used to refresh off-line tables from an external data source. I have a utility table where I am storing the last updated date. I would like to query that data dynamically when my form opens to update an unbound control. <br />
<br />
I don’t have much experience with VBA, but am guessing this would be a pretty easy tasks.<br />
<br />
The control name is: txLastUp<br />
The from name is: frmUtility<br />
The SQL to pull the value back via a query is: SELECT utlValue FROM tblUtility WHERE (((utlMod)='frmUtility') AND ((utlCode)='LASTUP'));<br />
<br />
Thank you in advance,<br />
Mike<br />

</div>
</div>


I have a MS Access 2007 database that is used to refresh off-line tables from an external data source. I have a utility table where I am storing the last updated date. I would like to query that data dynamically when my form opens to update an unbound control. 

I don’t have much experience with VBA, but am guessing this would be a pretty easy tasks.

The control name is: txLastUp
The from name is: frmUtility
The SQL to pull the value back via a query is: SELECT utlValue FROM tblUtility WHERE (((utlMod)='frmUtility') AND ((utlCode)='LASTUP'));

Thank you in advance,
Mike


Dynamically updating an unbound control from data stored in a table

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.