Special update form

  • Thread starter Thread starter Mike Collard
  • Start date Start date
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
 
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
 
Back
Top