Using Date Modified field with tabbed subform

  • Thread starter Terry B via AccessMonster.com
  • Start date
T

Terry B via AccessMonster.com

I have a main form with a tabbed form on it.
My first tab has company info on it and a read only Date Modified field.
In my Form's BeforeUpdate event I use:
Me![Last Modified] = Now() 'Date and time

This works fine if I modify something on the tabbed form, however;

The Tabbed form has another tabbed form within one of its tabs and if I
modify something
on that subform with tabs it does not update the date modified.

Any Ideas on how to do this?

I tried putting the same thing in the tabbed subforms before update event and
refering back the the
Date modified field by Forms!frmcontracts.[last modified] and I get an error
telling me another user
has made changes, Do I want to save them.

Main Form=frmContracts
Tabbed Form = TabMain
Tabbed Subform =TabSub

Thanks...
 
Top