R
riyaz.mansoor
Yeah, that sounds wierd 
I've got many tables with the same first 6 fields common to all
tables. To handle the operations on these fields I created a subform
(not a linked form but a normal data entry form with fields). The
fields on this subform have no RecordSource property as the "Main
Form" has the datasource. The subform is placed on the "Main Form"
with the other form fields. I can place the existing values for those
fields programmatically from within the OnCurrent method on the "Main
Form".
I am using Recordset backed forms.
In INSERT operations I need to read the fields in the subform and
programatically insert it SOMEWHERE. IE, the BeforeUpdate event is
triggered while the Recordset in NOT in AddNew mode.
What I need is to be able to catch the Update operation on the
Recordset. OR. A form method while the recordset is being updated.
Any help?
Riyaz
I've got many tables with the same first 6 fields common to all
tables. To handle the operations on these fields I created a subform
(not a linked form but a normal data entry form with fields). The
fields on this subform have no RecordSource property as the "Main
Form" has the datasource. The subform is placed on the "Main Form"
with the other form fields. I can place the existing values for those
fields programmatically from within the OnCurrent method on the "Main
Form".
I am using Recordset backed forms.
In INSERT operations I need to read the fields in the subform and
programatically insert it SOMEWHERE. IE, the BeforeUpdate event is
triggered while the Recordset in NOT in AddNew mode.
What I need is to be able to catch the Update operation on the
Recordset. OR. A form method while the recordset is being updated.
Any help?
Riyaz