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,