Hi All
I have following VBA code on Combo box after update but it does not work and showing message syntax error:
Code tags added by moderator.
Note:-
MatterID are Numbers and
TrxMode and description are Text. The criteria is to display records on sub form based on meeting selection of combo box 2 columns value.
I will really appreciate for any help.
Kind regards
I have following VBA code on Combo box after update but it does not work and showing message syntax error:
Code:
Private Sub cboTransaction_AfterUpdate()
Dim SQL As String
SQL = "Select Transaction.[ClientID], Transaction.[MatterID], Transaction.[TrxDate], Transaction.[TrxMode], " _
& "Transaction.[Description], Transaction.[DebitOffice], Transaction.[CreditOffice], Transaction.[DebitClient], " _
& "Transaction.[CreditClient] From Transaction WHERE Transaction.[ClientID]= " & nz(me.cboTransaction.Column(0),0) " _
& "AND Transaction.[MatterID]= " & nz(Me.cboTransaction.Column(1),0) & " " _
& "ORDER BY Transaction.[TrxDate] DESC;"
Me.subMatterTransactions.Form.RecordSource = SQL
Me.subMatterTransactions.Form.Requery
End Sub
Code tags added by moderator.
Note:-
MatterID are Numbers and
TrxMode and description are Text. The criteria is to display records on sub form based on meeting selection of combo box 2 columns value.
I will really appreciate for any help.
Kind regards
Last edited by a moderator: