Adding last modified date to switchboard

  • Thread starter Thread starter Mel
  • Start date Start date
M

Mel

I'm trying to get the last modifed date from a field in the
main table to display on the switchboard.

Any help is greatly appreciated.

Thanks
mel
 
I'm trying to get the last modifed date from a field in the
main table to display on the switchboard.

Any help is greatly appreciated.

Thanks
mel
Click to expand...

Add an unbound control to the Switchboard.
Set it's Control Source to:
=DMax("[ModifiedDateField]","TableName")
 
you could use an unbound control on the switchboard, with the following
expression as the ControlSource:

=DMax("DateFieldName","MainTableName")

this should find the most recent date in that field in that table, and
display it in the control.

hth
 
Thanks a lot!

Mel
-----Original Message-----
I'm trying to get the last modifed date from a field in the
main table to display on the switchboard.

Any help is greatly appreciated.

Thanks
mel
Click to expand...

Add an unbound control to the Switchboard.
Set it's Control Source to:
=DMax("[ModifiedDateField]","TableName")
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top