C
Chris
Hi,
I have a form with a subreport, when a user chooses an item from
a drop down list it populates the subreport, which returns many records from
SQL Server 2000
The sub report is editable in that any changes to a record is automatically
saved
to the database (automatically by the control).
When a user changes a particular column I would like 2 other fields in the
changed record to be updated as well.
one with the date time of the change.
the other field with the name of the person who made the change.
how might I go about doing this?
i feel there may be many differernt approaches to solve this problem ,
unfortunately all of which I need help on.
Thanks
Chris
I have a form with a subreport, when a user chooses an item from
a drop down list it populates the subreport, which returns many records from
SQL Server 2000
The sub report is editable in that any changes to a record is automatically
saved
to the database (automatically by the control).
When a user changes a particular column I would like 2 other fields in the
changed record to be updated as well.
one with the date time of the change.
the other field with the name of the person who made the change.
how might I go about doing this?
i feel there may be many differernt approaches to solve this problem ,
unfortunately all of which I need help on.
Thanks
Chris