Hi All,
Hopefully I explain this well........
In Access97 I have a form which has a tab control on it, each tab has a
sub-form which is bound to its appropriate table(I'll call them
'Detail' tables). I have a 'Header' table and fields from it are
displayed on the form above the tab control.
Header table name is tblClientInfo
Detail tables are tblPolicyInfo, tblBeneInfo, tblRiderInfo
In the tblClientInfo I have a TimeStamp field which I want to append to
when a user updates anything on each of the tabs so, how do I detect
that something was updated on the Policy Info tab and then append a
TimeStamp (ex: UserID updated Policy information on 01/19/05 at 2:14pm)
to the TimeStamp field in the tblClientInfo table. And then if the user
clicks on the Riders tab and updated something do the same except sub
"Rider information" for "Policy information".
I'm not sure how to detect if anything on the subform for the current
active tab has been updated, what's the vba coding to do this?
thanks for any and all help
bobh.