I am trying to put a little status bar that updates automatically based on newest or latest modified record in a table. I have some time and date fields built in to my "assets" table. They respond as desired and update when a record is created/modified etc. This status bar I speak of is on my switchboard and is built on an unbound text box. It's name is Date_TimeModified. I want the bar to update with the newest date of the latest modified record. I thought the following code might make it function.
Me.Date_TimeModified = Max ("[Assets]", "Date_Modified") but it returns an error. Any suggestions?