G
Guest
I have a table HYInReg which uses entry and edit forms to store records.
My requirement for our QMS (Quality Management System) is for a form to be
completed requesting a deletion from the records in the above table. I would
like the user (using the form) to select the record and confirm it is the
correct one and then to add additional information such as ‘request date’
‘person making request’ and ‘reason for request’. I would like then for ALL
the information to be passed to another table.
I would then like to view the entries in the table (as administrator / no
user should use this) via a form (preferably the same as previous) then again
add additional information such as ‘date of deletion’. Thus resulting in a
table of deleted records showing who, waht, why, where and when.
Could anybody please explain how I can achieve this, I can create tables and
forms and follow step by step instructions but do not understanding VB coding
very well. Many thanks in advance for all your help.
My requirement for our QMS (Quality Management System) is for a form to be
completed requesting a deletion from the records in the above table. I would
like the user (using the form) to select the record and confirm it is the
correct one and then to add additional information such as ‘request date’
‘person making request’ and ‘reason for request’. I would like then for ALL
the information to be passed to another table.
I would then like to view the entries in the table (as administrator / no
user should use this) via a form (preferably the same as previous) then again
add additional information such as ‘date of deletion’. Thus resulting in a
table of deleted records showing who, waht, why, where and when.
Could anybody please explain how I can achieve this, I can create tables and
forms and follow step by step instructions but do not understanding VB coding
very well. Many thanks in advance for all your help.