I'm trying to write a form-load function, which will read the property of a table in my db, and display on the form the date the table in question was last updated (sort of a systems check to be sure things are working correctly.) I have this piece of code, which my brain suggests should work properly, but of course this is Access, so it doesn't. Would appreciate any feedback I could get on this one. Thanks!!
Private Sub Form_Load()
Dim dbsRefmd As Database
Dim tdfDICT123 As TableDef
Set dbsRefmd = OpenDatabase("Refmd.mdb"
Set tdfDICT123 = dbsRefmd.TableDefs!DICT123
Form_MainMenu.Updated.Caption = "Last Updated: " & tdfTemp.LastUpdated
End Sub
Private Sub Form_Load()
Dim dbsRefmd As Database
Dim tdfDICT123 As TableDef
Set dbsRefmd = OpenDatabase("Refmd.mdb"
Set tdfDICT123 = dbsRefmd.TableDefs!DICT123
Form_MainMenu.Updated.Caption = "Last Updated: " & tdfTemp.LastUpdated
End Sub