What Constitutes a New Record

[CementCarver]

What constitutes a new record? I have a main customer form and if the client decides to add a new customer, I call up an edit form, but I prefill the customer name, customer type etc. So when the edit form pops up, several fields are already filled with data. The new customer record is already created behind the scenes prior to the edit form being displayed.

Odd thing though, the action that is being recorded, via Martin Greene's audit table code, is always...."EDIT" and never "NEW".

So does that mean that when the second form is called up that it's determined that any changes to the record is deemed an "EDIT"?

CementCarver

[June7]

If the 'new customer' record is committed to table before form opens then it is an existing record that is just being edited to include more details.

If you want to treat the record as 'new' will have to adjust code to handle that.

[CementCarver]

How does one change the code to make it a new record?

CementCarver

[June7]

I don't know your code so can't answer that.