M
Mike Collard
I have a form linked to a query that shows the current
record from a table that I want the user to update by
overtyping the displayed values. Each record has an
effective and inactive date with the current record having
an inactive date.
What I want to have happen is:
1. For the user to overtype appropriate field values and
click a Confirm button that will:-
2. End date the current record by updating the inactive
date to sysdate
3. Insert a new record based on the user entry with an
effective date of sysdate.
I guess the automatic update of the table needs to be
disabled in some way so that the current record is not
itself changed?
Grateful for any help
Mike Collard
record from a table that I want the user to update by
overtyping the displayed values. Each record has an
effective and inactive date with the current record having
an inactive date.
What I want to have happen is:
1. For the user to overtype appropriate field values and
click a Confirm button that will:-
2. End date the current record by updating the inactive
date to sysdate
3. Insert a new record based on the user entry with an
effective date of sysdate.
I guess the automatic update of the table needs to be
disabled in some way so that the current record is not
itself changed?
Grateful for any help
Mike Collard