Edd
Posts: 547
|
| Posted: 05/10/2005, 8:55 PM |
|
I am performing a logging function every time someone performs a delete - I am recording particulate details of the records they have deleted.
My issue is when the BeforeExecuteDelete fires, what is the reference to the record that is being deleting OR Is it deleting the whole set?
Is it
XXX.FIeldNAme.value
or
XXX.Datasource.Recordset.field("FIeldName")
If it is the latter what is the determination of the Deleded records?
Regards,
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
 |
 |
Nicole
Posts: 586
|
| Posted: 05/11/2005, 6:53 AM |
|
Edd,
You can try to obtain field values in Before Execute/Build Delete events using
Form_name.field_name.Value
These events are fired for each row which is marked to be deleted.
_________________
Regards,
Nicole |
|
|
|
Edd
Posts: 547
|
| Posted: 05/11/2005, 7:32 AM |
|
Nicole,
Sorry,
Quote :Form_name.field_name.Value
only returns the 1st item in the Datasource and not necessarily a deleted item - it must be in the datasource set.
I will ferret through the code, I was hoping for a quick answer.
Your answer is OK on single forms NOT on DataGrids.
Many thanks for responding.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
nebde
Posts: 3
|
| Posted: 05/18/2005, 12:44 AM |
|
Edd,
You can use the Before/After Delete event to reference on the particular record using the Form_Name.DataSource.Where.
The value of this is the primary key you set for the Grid.
Hope this help.
nebde
_________________
Regards,
nebde |
|
|
|
|
