|
Function BeforeAdd(dict)
'
Parameters:
' dict - Scripting.Dictionary object.
' Each field on the Add form represented as 'Field name'-'Field
value' pair
'********** Save new data in another table ************
dal.AnotherTable.Field1=dict(Field1)
dal.AnotherTable.Field2=dict(Field2)
dal.AnotherTable.Update()
BeforeAdd = True
' set BeforeAdd to True if you like to proceed with adding new record
' set it to False in other case
End
Function |