Special update form

[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

 

[Ed]

The general approach should be:
1. a new data form with an unbound text box for each field and
(this could include pre-setup from the existing record)
2. Code that will add a new record (see AddNew Method Example in help)

ed