Private Sub BatchVBARecord_AfterPost(ByVal sBatchName As String, ByVal lNumRecsPosted As Long, ByVal lNumExceptions As Long)

'CustomWhereClause to load the Gift Collection with just

'the gifts from the posted batch

'sBatchName is the Batch Number, note if it is a recurring

'batch than it is for the original batch, not as it is

'being committed

Dim sWhereClause As String

sWhereClause = "Batch_Number='" & sBatchName & "'"

Dim oGifts As CGifts

Set oGifts = New CGifts

oGifts.Init REApplication.SessionContext, tvf_Gift_CustomWhereClause, sWhereClause

Debug.Print oGifts.Count

Dim oGift As CGift

'Loop through the gifts

For Each oGift In oGifts

   'System ID of the Gift - this is the back end ID

   Debug.Print oGift.Fields(GIFT_fld_ID)


Next oGift

'Clean up


Set oGifts = Nothing

End Sub

Disclaimer: We provide programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes you are familiar with Microsoft Visual Basic and the tools used to create and debug procedures. Our Customer Support can help explain the functionality of a particular procedure, but we will not modify, or assist you with modifying, these examples to provide additional functionality. If you are interested in learning more about the VBA and API modules, contact your account manager.