Date Controls that change when a DB is updated

[stormin38]

Question 2 in a long list...
I need to add an update date to the main page only of my switchboard. I have added a text box and label and stuck in a date time control but it is displaying on every sub-switchboard page as well.

First, I need to get it to show ONLY on the first switchboard page.

Second, I need to get it to update only when a particular table within the database is changed.

Thanks in advance.
Tracy

 

[CautionMP]

stormin38,
[ol][li]You can use the same logic from my other post ([navy]Sub-Switchboard Headers[/navy] thread181-1237883) to hide/show your new textbox and label only when the 'default' switchboard is displayed.[/li]
[li]Not exactly sure what you mean but you can use the [tt]DLookup()[/tt] function to return the last date and time a table was modified. This example will return the last time the Switchboard Items table was modified.

[b]YourTextBoxName[/b] = Dlookup("DateUpdate","MSysObjects","Name='Switchboard Items'")

[/li][/ol]

Hope this helps,
CMP

(GMT-07:00) Mountain Time (US & Canada)