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"
If chkPending = 1 Then
strSource = "sqryOFCDEPTLedgerBalances_NoPending_2"
Form_frmOFCDEPTLedgerBalances_subform.RecordSource = strSource