D
DJM
Hi all,
Have a main form 'User details' and subform 'System Access', which is
assigned to user. When a new system is added or amended for the User
(subform), I have built in an OnChange event from one of the populated
fields on the subform to run an update query to populate a seperate log
table with the new user data and the database users, who created the data
row, etc.
This works fine, assuming the database user changes the required field to
trigger the OnChange event.
I'm looking for a better way to run this from an event on the main form
(i.e. from an update button). As the database user could be setting up
several new systems for the user in one session, I'd like to populate only
the data that has been added or amended on the subform. At present when I
run this event from the main form, it populates all the subform data to the
log table (not just the updated data). I'm thinking that I need to use
another event or Form.Dirty, but would welcome a few opinions on the best
approach?
Cheers
D
Have a main form 'User details' and subform 'System Access', which is
assigned to user. When a new system is added or amended for the User
(subform), I have built in an OnChange event from one of the populated
fields on the subform to run an update query to populate a seperate log
table with the new user data and the database users, who created the data
row, etc.
This works fine, assuming the database user changes the required field to
trigger the OnChange event.
I'm looking for a better way to run this from an event on the main form
(i.e. from an update button). As the database user could be setting up
several new systems for the user in one session, I'd like to populate only
the data that has been added or amended on the subform. At present when I
run this event from the main form, it populates all the subform data to the
log table (not just the updated data). I'm thinking that I need to use
another event or Form.Dirty, but would welcome a few opinions on the best
approach?
Cheers
D