M
Matt Weyland
Background:
I have a user form that I need to keep track of what
changes from what to what and log this information into an
event log.
In the DB there is a project. For every project there can
be one or more Beneficiaries for that project.
Problem:
In my attempts to keep the information that is active
in the table and the information on the form separate I
thought it best to create a recordset and manually feed
the information into the form. From there do a comparison
against the current informtion on the form vs. the
information stored in the table and for those values log
an event (i.e. Changed fname from Joe to Phil), then
update the table.
I am doing something like this for another type of
relation to the Project. For every project there is one
Provider. I have implemented this and it works well.
The problem is that I would now like to do this for a
one to many relationship.
Efforts thus far:
I have created pointed the form to the respective query to
pull the information I need. Problem is that once the
information is modified the record is updated
automatically and I can't capture the information to be
logged. I could do something to the after update event of
the text box, but it may change to something, then back to
something which wouldn't result in any change at all,due
to some type of typo or to that effect.
This seems like it should be a fairly easy thing to
implement. Any suggestions Ideas is greatly appreciated.
Post responses here or email me at.
mweyland at mnqio dot sdps dot org
I have a user form that I need to keep track of what
changes from what to what and log this information into an
event log.
In the DB there is a project. For every project there can
be one or more Beneficiaries for that project.
Problem:
In my attempts to keep the information that is active
in the table and the information on the form separate I
thought it best to create a recordset and manually feed
the information into the form. From there do a comparison
against the current informtion on the form vs. the
information stored in the table and for those values log
an event (i.e. Changed fname from Joe to Phil), then
update the table.
I am doing something like this for another type of
relation to the Project. For every project there is one
Provider. I have implemented this and it works well.
The problem is that I would now like to do this for a
one to many relationship.
Efforts thus far:
I have created pointed the form to the respective query to
pull the information I need. Problem is that once the
information is modified the record is updated
automatically and I can't capture the information to be
logged. I could do something to the after update event of
the text box, but it may change to something, then back to
something which wouldn't result in any change at all,due
to some type of typo or to that effect.
This seems like it should be a fairly easy thing to
implement. Any suggestions Ideas is greatly appreciated.
Post responses here or email me at.
mweyland at mnqio dot sdps dot org