marku24

<div>
so simple yet i would have never figured that out.&nbsp; thank you&nbsp;
</div>


<div>
<div class="content wysiwyg-content fr-view">
<p>Changing a subform's record source based on a check box result through VBA. &nbsp;I want to change the record source from a TABLE to a QUERY but assume the syntax of calling each is wrong. &nbsp;see below:</p><p><br></p><p>Dim strSource As String<br id="isPasted">&nbsp;<br>&nbsp; &nbsp; If chkPending = 0 Then<br>&nbsp; &nbsp; strSource = "tbl_MAP Product Pricing-Repository"<br>&nbsp; &nbsp; End If<br>&nbsp;<br>&nbsp; &nbsp; If chkPending = 1 Then<br>&nbsp; &nbsp; strSource = "sqryOFCDEPTLedgerBalances_NoPending_2"<br>&nbsp; &nbsp; End If<br>&nbsp;&nbsp;<br>&nbsp; &nbsp;<br>&nbsp; Form_frmOFCDEPTLedgerBalances_subform.RecordSource = strSource</p>
</div>
</div>



Changing a subform's record source based on a check box result through VBA.  I want to change the record source from a TABLE to a QUERY but assume the syntax of calling each is wrong.  see below:
Dim strSource As String
 
    If chkPending = 0 Then
    strSource = "tbl_MAP Product Pricing-Repository"
    End If
 
    If chkPending = 1 Then
    strSource = "sqryOFCDEPTLedgerBalances_NoPending_2"
    End If
  
   
  Form_frmOFCDEPTLedgerBalances_subform.RecordSource = strSource

Change Record Source in VBA based on Check Box Result

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.