Public Sub GiftStatus()
    Dim oGift As CGift
    Set oGift = New CGift
    oGift.Init REApplication.SessionContext
    oGift.Load 2075
   
    Dim lID As Long 'Recurring gift ID
   
    lID = oGift.PledgePayer.RGActivity.Fields(RECURRINGGIFTACTIVITY_fld_RecurringGiftId)
   
    Dim oRecur As CGift
    Set oRecur = New CGift
    oRecur.Init REApplication.SessionContext
    oRecur.Load lID
   
    Debug.Print oRecur.Fields(GIFT_fld_Gift_Status)
   
    oRecur.Closedown
    Set oRecur = Nothing
   
    oGift.Closedown
    Set oGift = Nothing
End Sub

Blackbaud provides 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 that you are familiar with Microsoft Visual Basic and the tools used to create and debug procedures.  Blackbaud Customer Support can help explain the functionality of a particular procedure but they will not modify, or assist you with modifying, these examples to provide additional functionality.  If you are interested in learning more about VBA and API modules, contact our Sales department at solutions@blackbaud.com.